Thanks guys!

Looks like DOLLAR() is the best choice.

Biff

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