Hi Jason,

I was in a hurry, so didnt ask in my previous post.

How should I interpret or evaluate an expression like
$#,##0.00_);[Red]($#,##0.00);"NULL";@
I can understand formuals written (and if not able to, I use the evaluate
formula feature) but the above is greek to me. Whats the logic for these?

Is there some website/link explaining about manipulating custom formats.

--
Thanks a lot,
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


.