Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
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 ??
Not quite sure what you mean by "Box". What's the cell number format? [nt]
Posted by Mark W. on February 15, 2002 11:07 AM
cell shows blank, we need to have 0.00 on the worksheet
Posted by kelly j on February 15, 2002 12:14 PM
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 ??
cell shows blank, we need to have 0.00 on the worksheet
Posted by kelly j on February 15, 2002 12:20 PM
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 ??
Re: cell shows blank, we need to have 0.00 on the worksheet
Posted by Mark W. on February 15, 2002 12:34 PM
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?
Re: cell shows blank, we need to have 0.00 on the worksheet
Posted by antonio on April 26, 2002 2:42 AM
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
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.