Zeros in work sheet

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?
 
R

Romulus

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.
 
B

Bernard Liengme

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
 
D

Dave Peterson

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?
 
M

Maxi

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
 
P

Patrick Simonds

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?
 
Top