Zeros in work sheet

  • Thread starter Thread starter DrBryanJ
  • Start date Start date
D

DrBryanJ

When I enter the number 0 in the work sheet it comes up
zero. The function that looks at that cell then give
erroneous values. How do I make the cell display 0?
 
Hello DrBryanJ,

Because sometimes Excel treats information entered in a cell as text,
not as numbers, try this one: find an empty cell and write 1 in it.
Then copy the cell, select all cells containing "rebel" zeros, use
Paste special -> Operation: Multiply. Maybe it will help you. Or,
please make sure you did not divided by zero with mentioned formulas.
 
Depends what the function is. Would you like to share that with us?
If you are dividing by A1 and A1 is 0 then use =IF(A1=0,"cannot do", B1/A1)
Of course, the second argument can be anything you like as in =IF(A1=0,0,
B1/A1)
Bernard
 
Try formatting column G and H as general, then retype your 0 and 3.

If that fixes it, you can fix all of G:H by formatting them as General, then
select an unused cell and copy it.

then select G:H and edit|Paste special|check Add.

This'll convert all the existing text numbers to number numbers.

And you can ignore this if it's too stupid:
You're not typing: 0 - 3 in one cell, are you?
 
I am ending up with zeros, when my original sheet / cells are blank, and I want it to remain blank. How do I get rid of the zeros?

THanks
 
Tools
Options
View
Window Options
remove the check mark for zero values


Maxi said:
I am ending up with zeros, when my original sheet / cells are blank, and I
Click to expand...
want it to remain blank. How do I get rid of the zeros?
 
Back
Top