I have a .csv file where fields may have value "01234".

When I read this file into Excel, I want the cell to be formatted as text
(so the 0 is retained). By default Excel formats as numeric and loses the 0.

There is an alternative where I can rename the file as .txt and use the
wizard, but I want to see if there is a simpler alternative.

I have tried prefixing the field with "'" character, but that resyults in
the value "101234" in the cell.

Any ideas?