Force a blank cell to zero

[Roz]

How can I force a blank cell to equal 0 in a column?

[pinmaster]

Roz

Blank cells always equal 0. To prove it type =A1 in a cell, if A1 is blank it will return 0.

Regards
JG

[JMay]

A quick way to do what you are asking is as follows:
Select the column say column C (click on the "C")
that already has your data in it.
Press the F5 function key - from dialog box click on Special... then click on
BLANK, OK.
The used range (only) of Column C will be selected (highlighted). The first
blank cell will become the activecell.
In it enter 0 (that's zero) <<DO NOT PRESS ENTER,,,
Instead Press CONTROL + Enter (simultaneously).
All previous blanks should now = 0

HTH





"Roz" <Roz.20enga_1135193701.136@excelforum-nospam.com> wrote in message
news:Roz.20enga_1135193701.136@excelforum-nospam.com...
>
> How can I force a blank cell to equal 0 in a column?
>
>
> --
> Roz
> ------------------------------------------------------------------------
> Roz's Profile:
> http://www.excelforum.com/member.php...o&userid=29746
> View this thread: http://www.excelforum.com/showthread...hreadid=495299
>

[tghcogo]

Roz

Blank cells always equal 0. To prove it type =A1 in a cell, if A1 is blank it will return 0.

Regards
JG

This is providing you have ticked the "zero values" box in Tools/options/view - window options