Its like somebody would be typing a number in to cell B4 and if that
number
is zero then it should get displayed in the cell as NULL

I know it's not what you asked, but would using Data | Validation help you
by preventing zero's from being entered in the first place? One advantage
would be that if someone entered a zero, then Excel could display your
custom message explaining the error. (ie. "Please only enter non-zero
numbers"...or whatever..)

If you would like to experiment with this feature, select your range of
cells, (say A1:A100) and select Data | Validation.
Under the Settings tab, select "Custom" under the Allow: box.
For the formula, enter =A1 < 0.
It is important to note that "A1" is the first cell in your selection.
Excel will correctly adjust the address for the other cells when you hit ok.
For "Input Message" and "Error Alert", enter your information that explains
to users what you expect.

HTH
--
Dana DeLouis
Win XP & Office 2003


"Hari Prasadh" wrote in message
...
Hi Jason,

Thnx a ton.

--
Regards,
Hari
India

"Jason Morin" wrote in message
...
The XL help file actually does a decent job of explaining
formats. Here are some other links to help you:

http://j-walk.com/ss/excel/tips/tip19.htm
(download the file)

http://office.microsoft.com/en-
us/assistance/HP051986791033.aspx

http://office.microsoft.com/en-
us/assistance/HP052075951033.aspx

HTH
Jason
Atlanta, GA

-----Original Message-----
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


.



.