G
Guest
How can I get excel to import a csv file with entries like "000111" and
format it as text
My database creates a csv file to load into excel
It contains a name and a id field
eg
"joe bloggs","jb01"
this loads into excel no problem both columns formatted as text as needed
unfortunately some of the ids begin with zero and only contain numbers
when loaded into excel they are convereted to numbers and leading zeros
chopped off. I need them to stay as text
I can make excel display leading zeros - but its still a formatted as a
number - no good!
Using a ' on the front loads in correctly but as soon as the ' is removed it
reverts to a number
Thanks
format it as text
My database creates a csv file to load into excel
It contains a name and a id field
eg
"joe bloggs","jb01"
this loads into excel no problem both columns formatted as text as needed
unfortunately some of the ids begin with zero and only contain numbers
when loaded into excel they are convereted to numbers and leading zeros
chopped off. I need them to stay as text
I can make excel display leading zeros - but its still a formatted as a
number - no good!
Using a ' on the front loads in correctly but as soon as the ' is removed it
reverts to a number
Thanks