Hi Jason,

You saved the day for one of my friends!!!

Thnx a ton.
--
Regards,
Hari
India

"Jason Morin" wrote in message
...
Try a custom format of:

$#,##0.00_);[Red]($#,##0.00);"NULL";@

HTH
Jason
Atlanta, GA


-----Original Message-----
Hi,

I can do the following using a helper cell in conjunction
with IF formula
but I dont/cannot do it that way for the present purpose.

In B4 if a cell displays zero it should display as -
NULL - but if it is
some number like - 32,567 - then it should display
32,567 as it is.

Can this be achieved through custom formatting. Please
suggest.

Please note B4 contains dollar amounts.
--
Thanks a lot,
Hari
India


.