MrExcel Publishing
Your One Stop for Excel Tips & Solutions

CAN SEE A 0 IN THE BOX, BUT IT WON'T SHOW IN THE CELL


Posted by KELLY J on February 15, 2002 11:01 AM

WHY CAN WE SEE THE '0' ON THE BOX ABOVE BUT WE CANNOT GET ANY 0.00 TO SHOW UP IN THE CELL ??


Posted by Mark W. on February 15, 2002 11:07 AM

Not quite sure what you mean by "Box". What's the cell number format? [nt]

Posted by kelly j on February 15, 2002 12:14 PM

cell shows blank, we need to have 0.00 on the worksheet

the cell is formatted as a number with 2 decimals but the cell is a blank, it will not allow me to change the cell so it will show the 0.00,you can only see 0 on the formula bar, why ??


Posted by kelly j on February 15, 2002 12:20 PM

cell shows blank, we need to have 0.00 on the worksheet

the cell is formatted as a number with 2 decimals but the cell is a blank, it will not allow me to change the cell so it will show the 0.00,you can only see 0 on the formula bar, why ??


Posted by Mark W. on February 15, 2002 12:34 PM

Re: cell shows blank, we need to have 0.00 on the worksheet

If you select the cell and choose the Format | Cells...
menu command what do you see listed as the format
Category? If it's "Custom" what's in the
Type field?


Posted by antonio on April 26, 2002 2:42 AM

Re: cell shows blank, we need to have 0.00 on the worksheet


Dear Kelly, u need to click on Tools > Options and under View > Window Options tick on show zero values. Hope that works out 4 u. Cheerio