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

--
Patrick