How do I show a zero?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Linds said:
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!
Click to expand...

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
 
Hi Linds. Put an apostrophe ' in front of the number to make it text, as you
enter it. HTH
 
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
 
Back
Top