How do I show a zero?
 

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!

How do I show a zero?
 

Linds wrote:
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

How do I show a zero?
 

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


"Linds" wrote:

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!

How do I show a zero?
 

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

"Linds" wrote:

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!

How do I show a zero?
 

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

On Fri, 4 Aug 2006 15:16:03 -0700, Linds
wrote:

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!