Leading Zeroes

M

melissa

I was wondering how to include "000" at the beginning of a data value,
because the data set I am creating includes ID numbers. Excel wipes out the
zeroes once I put them in the cell. For example, I would like to have it
written as 000112233 instead of "112233."

Thank you for your help.
 
C

CLR

Either pre-format the cell as TEXT, or type a leading apostrophe before the
zeros....it won't show, but formats that cell as TEXT.

hth
Vaya con Dios,
Chuck, CABGx3
 
J

James Silverton

Hello, melissa!
You wrote on Wed, 11 Oct 2006 11:15:03 -0700:

m> I was wondering how to include "000" at the beginning of a
m> data value, because the data set I am creating includes ID
m> numbers. Excel wipes out the zeroes once I put them in the
m> cell. For example, I would like to have it written as
m> 000112233 instead of "112233."

m> Thank you for your help.

If the result is to be a fixed length, use a custom font with
that number of zeroes. For example, if 112233 is to be
000112233, the custom font would be 000000000. The numbers will
still be numbers not text.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
 
Top