View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Delimiting and Formatting Delimiting and Formatting is offline
external usenet poster
 
Posts: 1
Default Delimiting and Formatting

I am trying to delimit a string of data, which contains, in one column, a
series of six digits which start with the number zero. After typing the
number in the zero is remove, i.e. I enter 001234 then becomes 1234. Is it
possible for the zero(s) to remain a part of the entry? PLEASE HELP!