Thread: Leading Zeroes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Melissa Melissa is offline
external usenet poster
 
Posts: 122
Default Leading Zeroes

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.