Make numbers 19.3 output shoud look like 19.30 for dollars

[RodM]

I am stuck.. my fields are numbers, if I use a layout.. I can use the format to set 00.00 with 2 decimals..

Without though, my data is being sent out to email and other outputs with not 2 deciamls for dollars....

..my data examples look like 19.3 or 10.

I am pretty new to this.. I went through the number functions list

[RodM]

I impressed myself... never used a function b4.. or even considered those kinds of things

This fixed did it

fnNumberFormat ( number ; decimals ; dec_point ; thousands_sep ); 2 ;"." ; ",")

[PotzUK]

If( Length( Mod( [NUMBER] ; 1 ) ) = 2 ; n & "0" ; n )

Edited September 23, 2009 by Guest