Also Custom format works like this...

Postive numbers;Negative Numbers;Zero

So if you want it to show decimal points, then you would need something like
this as a custom format...

#.00;#.00;""

If you are dealing with whole numbers, this isn't necessary and # by itself
will be appropiate.

"Sloth" wrote:

Make a custom format and use this as your format type...

#

"samerry" wrote:

I have copied a formula down several rows for future data to be entered and
calculated. In the formula column it shows "0". I would like for the "0" not
to show. Does anyone know how to make the "0" go away without deleting the
formula. Data will later be entered in the appropriate rows and need to be
calculated at the appropriate time.