Concatenating string & number 2

[jscranton]

Hi,

This is a straightforward question but I can't figure it out. I'd like to create a simple formula that displays some text and a numerical field. E.g., "The number of items is: 5"

I'm using the ToText function to convert the number, but it comes out with a decimal point, i.e., 5.00 instead of 5.

Any ideas how I can make it display without the decimal?

Thanks & regards,
James

 

[LV]

Try totext(Number, 0), this will cut off all decimal points.

 

[jscranton]

Thanks!