Force a blank cell to zero

  • Thread starter Thread starter Roz
  • Start date Start date
Roz

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

Regards
JG
 
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
 
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
Click to expand...

This is providing you have ticked the "zero values" box i
Tools/options/view - window option
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about conditional formatting of zeros in Excel 0
keeping a cell blank 4
null vs zero in regression analysis 2
BLANK CELLS 2
Blank Cell Reference, without if statement 4
2 Q's: moving cursor / forcing a response 1
Using COUNTA and excluding formulas that gives zero or blank cells 3
force to single column 4

Back
Top