R
Roz
How can I force a blank cell to equal 0 in a column
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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
Blank cells always equal 0. To prove it type =A1 in a cell, if A1 is
blank it will return 0.
Regards
JG
J
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
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
T
tghcogo
pinmaster said:Roz
Blank cells always equal 0. To prove it type =A1 in a cell, if A1 i
blank it will return 0.
Regards
JG
This is providing you have ticked the "zero values" box i
Tools/options/view - window option