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.

Format the cells as Text.
Right-click, Format Cells, Number Tab.
Select Text.

HTH,
Paul

"melissa" wrote in message
...
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.

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



"melissa" wrote:

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.

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