Number format using TEXT( ) function
Maybe
=DOLLAR(A4,(MOD(A4,1)<0)*2)
"T. Valko" wrote:
Hi Folks!
Using the TEXT() function, what format do I need to get:
$10
$10.50
$110.99
$1,110.99
Integers should remain integers but it should also handle decimals.
I tried $#,### which works fine on intergers but not on the decimals. Then I
tried $#,###.## which works fine on the decimals but not the integers.
Thanks
Biff
|