how do I get a formula to not show the amount but still be there

I need to have a formula entered but I do not want the zero to show

monkee, here is one way,

=IF(A1="","",A1)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"monkee" <monkee@discussions.microsoft.com> wrote in message
news:355C7C32-B915-4892-98B3-882F7799CB7F@microsoft.com...
>I need to have a formula entered but I do not want the zero to show

Other ways

1..set worksheet to not show zero values by selecting from menu
Tools, options, view tab, deselect zero values.



2. set a conditional format to turn font colour to same colour as background where the cell value is between certain values (eg between -0.5 and 0.5)

ruthki