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 -
|