zero dispay.

R

Raymond

I want to display 3 zero in a cell, but after pressing the enter key, there
is only 1 zero displays. How do I fix this?
 
J

JulieD

Hi Raymond

if you're happy for your 000 to be treated as text rather than numbers (ie
you're not performing any calculations with them) type an apostraphe before
the 000
'000
and press enter the ' will not display or print but forces the entry to
"text"

or format the cell as "text" (format / cells - number tab) and then enter
the 000

or if they need to be numbers use a custom format
click on the cell - choose format / cells - number tab, click on custom
in the type box type
000
click the OK button

Hope this helps
Cheers
JulieD
 
Top