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!