How do I show a zero?

[Guest]

I have numbers in a spredhseet that represent gift certificate numbers. They
all start with zeros, but the zxero disappears when I enter the value. How
can I make sure the zero is represented for that cell. Thanks!

 

[Scoops]

I have numbers in a spredhseet that represent gift certificate numbers. They
all start with zeros, but the zxero disappears when I enter the value. How
can I make sure the zero is represented for that cell. Thanks!

Hi Linds

Either

Format your cells as Text and re-enter the data (select the cells,
press F2 and press Enter)

or

Apply a Custom format of 00000 (as many zeros as your numbers are long)

or

When entering the numbers start the entry with an apostrophe (').

Regards

Steve

 

[Guest]

Have it enterered like '001. Inlcude the first character '

 

[Guest]

Hi Linds. Put an apostrophe ' in front of the number to make it text, as you
enter it. HTH

 

[Gord Dibben]

Pre-format the cells as text before entering.

Precede each number with an apostrophe.

Format as Custom 0000000 or whatever number of 0's you need to have one at
beginning.

Any one of the above should do the job.


Gord Dibben MS Excel MVP