Removing the unnecessary part <g. Don't know how to do it w/Text.

=DOLLAR(A4,(MOD(A4,1)0)*2)


"JMB" wrote:

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