Thread: text to columns trouble with "zeros"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelUser777 ExcelUser777 is offline
external usenet poster
  
Posts: 5
Default text to columns trouble with "zeros"
Hi

I want to get 01-0000000-00000001 to look like below...


Cell a1 = 01
Cell b1 = 0000000
Cell c1 = 00000001

I keep getting

Cell a1 = 1
Cell b1 = 0
Cell c1 = 1

I use "-" as my delimiter....


Thanks,
ExcelUser777

Reply With QuoteReply With Quote