changing formates
 

I am trying to insert a lot of figures into a excel document,however when I
leave the cell, the zero at the beginning of the numbers always disappears,
how can I change this so it doesn't happen and the whole number stays in the
field?

changing formates
 

format as text or a custom format for the number of digits
000000

--
Don Guillett
SalesAid Software

"milly8506" wrote in message
...
I am trying to insert a lot of figures into a excel document,however when I
leave the cell, the zero at the beginning of the numbers always
disappears,
how can I change this so it doesn't happen and the whole number stays in
the
field?

changing formates
 

milly

Precede the number with an apostrophe or pre-format the cells as Text.


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 05:57:01 -0700, milly8506
wrote:

I am trying to insert a lot of figures into a excel document,however when I
leave the cell, the zero at the beginning of the numbers always disappears,
how can I change this so it doesn't happen and the whole number stays in the
field?