Thread: Leading Zeroes
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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.