Here is a formula which will format the numbers as text including the comma separator for the thousands and if the number does not have any decimals it will add .0 to the end so that the formatting will look consistent.

// just substitute in your field name in the line below

var number Value = [My Number];

var text MyNumberInTextFormatRaw =

ToFormattedText(Round($Value,0.1),"comma_dot");

var text MyNumberInTextFormat =

If(not Contains($MyNumberInTextFormatRaw,"."), $MyNumberInTextFormatRaw & ".0", $MyNumberInTextFormatRaw);

If($Value <0, "<b><font color=red>" & $MyNumberInTextFormat, $MyNumberInTextFormat)

------------------------------

Mark Shnier (YQC)

Quick Base Solution Provider

Your Quick Base Coach

http://QuickBaseCoach.commark.shnier@gmail.com

------------------------------