Thanks, J!

The TEXT() function is part of a VLOOKUP formula. I could work that DOLLAR()
in but I'd prefer to use TEXT() and just come up with the correct format
style if there is one!

Biff

"JMB" wrote in message
...
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