V
Vasey
When I type a zero number into a cell and press return key the number
dissapears from view in the cell.
Any help appriciated.
dissapears from view in the cell.
Any help appriciated.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
One quick diagnose, click Tools>Options>View tab
Is "Zero values" unchecked? Check it > OK
Aloha? hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
Is "Zero values" unchecked? Check it > OK
Aloha? hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
D
Dave Peterson
Does the 0 still show up in the formula bar (at the top)?
If yes, then I'd check here first:
Tools|Options|View tab|
see if zero values is unchecked
If it is, then check that option.
If yes, then I'd check here first:
Tools|Options|View tab|
see if zero values is unchecked
If it is, then check that option.
D
David Biddulph
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.
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.
P
Pete_UK
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
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