Home » Category » Microsoft Excel

Microsoft Excel: Zeros in work sheet

205| Thu, 22 May 2008 23:47:00 GMT| anonymous| Comments (5)
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?

Keywords & Tags: zeros, work, sheet, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495044/
 
«« Prev - Next »» 5 helpful answers below.
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.

---
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

romulus | Thu, 22 May 2008 23:48:00 GMT |

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

"DrBryanJ" <DrBryanJ...optonline.net> wrote in message
news:0e1a01c38da0$684d0e30$a301280a...phx.gbl...
> 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?

bernard | Thu, 22 May 2008 23:49:00 GMT |

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?

DrBryanJ wrote:
> This is the function: =IF(G12="-",0,IF(G12>H12,3,IF
> (G12=H12,1,0))) The function looks at the score of a
> soccer game and determins the number of points a team
> recieves toward their standings in the league. It should
> return a value of 3 if Team g winns game and a value of 1
> if there is a tie and a value of 0 if team h wins. The
> first part g12="-" works fine it returns a value of 0
> when no score is entered yet. It is the G12>H12 that is
> the problem. When I type a score of 0 - 3 the worksheet
> chenges the 0 to text form zero. When the function looks
> at the binary value it sees zero as greater than 1 and
> returns a value of 3 instead of 0.
> I need the cell to display the number 0 instead of the
> text zero.
--

Dave Peterson
ec35720...msn.com

dave | Thu, 22 May 2008 23:50:00 GMT |

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

anonymous | Thu, 22 May 2008 23:51:00 GMT |

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

"Maxi" <anonymous...discussions.microsoft.com> wrote in message
news:07C5C0EA-B51C-4612-ACE0-22A5AF39D167...microsoft.com...
> 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

patrick | Thu, 22 May 2008 23:52:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories