Thousands separator

[Former Member]

Post Author: soccermock

CA Forum: Formula

Hi,

This is a simple one, I am sure. I am converting a number to text using ToText, but I can't figure out how to make the formula exclude the thousands separator. I want 1,000 to show as 1000.

Can anyone help?

Thanks!

[Former Member]

Post Author: ReubenECC

CA Forum: Formula

The other thing that works is to do ToText(, "####") if you know your number is 4 digits and you don't want decimals.

[Former Member]

Post Author: SKodidine

CA Forum: Formula

totext(,0,'',''); This will show numbers without decimals and separators. For example, 123456. If you need decimals then replace the zero with the number of decimal places and put a period between the last pair of quotes. For example, if you need 3 decimal places such as 123456.123 then totext(,3,'','.')