View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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 -