try

=IF(formula=0, [spacebar], formula)

and by [spacebar], I mean just leave it empty

"samerry" wrote in message
...
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.

How do you get rid of 0 when data not in formula row yet?
 

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.

Us an IF statement in your formula.

=IF(A1="","",formula)

HTH,
Paul


"samerry" wrote in message
...
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.

You could also use Joe's formula, but I believe you'll need to use a two
double quotes instead of a space.

=IF(formula=0,"",formula)


"PCLIVE" wrote in message
...
Us an IF statement in your formula.

=IF(A1="","",formula)

HTH,
Paul


"samerry" wrote in message
...
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.

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.

Do I add this to the =SUM formula in the same cell?

"PCLIVE" wrote:

You could also use Joe's formula, but I believe you'll need to use a two
double quotes instead of a space.

=IF(formula=0,"",formula)


"PCLIVE" wrote in message
...
Us an IF statement in your formula.

=IF(A1="","",formula)

HTH,
Paul


"samerry" wrote in message
...
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.

Yes,

Example:

=IF(SUM(A1:A3)=0,"",SUM(A1:A3))

This basically states that if your formula results "0", then the cell
remains blank, otherwise display the results of your formula.

Paul


"samerry" wrote in message
...
Do I add this to the =SUM formula in the same cell?

"PCLIVE" wrote:

You could also use Joe's formula, but I believe you'll need to use a two
double quotes instead of a space.

=IF(formula=0,"",formula)


"PCLIVE" wrote in message
...
Us an IF statement in your formula.

=IF(A1="","",formula)

HTH,
Paul


"samerry" wrote in message
...
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.

Go into Tools--Options--View and uncheck Show Zero Values. This should work.
I use it all the time in complex pivot tables, etc.

"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.

You could use Tools...Options...View and uncheck the Zero Values box, but
that may not be what you want if you need to see zero values when the data
is entered...

"samerry" wrote in message
...
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.

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.