When including numeric values in the expression to build up a character string, it’s common to use the Trim (removes leading and trailing spaces) and Str (converts numerics to characters) functions together, such as: Trim(Str(MyValue))

The equivalent when programming in Excel is the Cstr() function, so why not go ahead and build yourself a custom function in Monarch to do the same thing?

Bookmark and share this entry: