Force a blank cell to zero
 

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

Force a blank cell to zero
 

Roz

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

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495299

Force a blank cell to zero
 

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

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

Force a blank cell to zero
 

pinmaster Wrote:
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


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=495299