| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
when I type zero cell is blank
Or you might have Conditional Formatting set for that cell, such that
the foreground colour is white when the cell contents are zero. Just change the background colour to see if the zero appears in white. Hope this helps. Pete On Aug 3, 3:21*pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: Tools/ Options/ View: Check: Zero values If it isn't that, make sure that you haven't got a custom formatting which hides zeroes. #,##0;-#,##0 would show zeroes; *#,##0;-#,##0; wouldn't. -- David Biddulph "Vasey" wrote in message ... When I type a zero number into a cell and press return key the number dissapears from view in the cell. Any help appriciated.- Hide quoted text - - Show quoted text - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula setting cell type to blank and conditional formatting | Excel Worksheet Functions | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| how do I get my blank lesson plan on micros.word to type on and se | Excel Discussion (Misc queries) | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Threaded Mode
