Leading Zeroes
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.
|