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
|