Number to Text field - maintaining commas

This post is a bit old now but for those who see this and need help still if you want commas to start appearing appear after 3 digits you can use it like ToFormattedText(9000, "comma_dot", 3) => 9,000.

Here is the description from Quick Base:

ToFormattedText (Number n, Text f, Number c) Description: Returns a Text value containing the formatted print representation of the number n, using the format f, with separators starting after number c digits.  Valid values for c are 3 or 4; if it is 3, separators will be shown starting after 3 digits instead of after 4. Example: ToFormattedText(1234.56,"comma_dot", 3) returns "4,567.89" ToFormattedText(1234.56,"comma_dot", 4) returns "4567.89" ToFormattedText(1234567.89,"comma_dot_2",3) returns "12,34,567.89" ToFormattedText(1234.56,"dot_comma", 3) returns "4.567,89" ToFormattedText(1234.56,"dot_comma", 4) returns "4567,89" ToFormattedText(1234567.89,"dot_comma_2",3) returns "12.34.567,89"

------------------------------
Bram Tyler
------------------------------