View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default excel xls to csv numbers stored as txt lose first 0

When you change to .CSV, Excel reformats each field as it deems fit. You
could either add a ' prior to each number or format as text after conversion,
then add leading 0's...

"steve44122" wrote:

we have a mix field with some having only numbers. it is text. when
converting it to a csv the 0 in the first column are lost.... this happens
only to fields that are only numeric