When I type a zero number into a cell and press return key the number
dissapears from view in the cell.

Any help appriciated.

One quick diagnose, click ToolsOptionsView 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
---
"Vasey" wrote:
When I type a zero number into a cell and press return key the number
dissapears from view in the cell.

Any help appreciated.

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.


Vasey wrote:

When I type a zero number into a cell and press return key the number
dissapears from view in the cell.

Any help appriciated.

--

Dave Peterson

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.

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 -