You dont need to rename the file instead in 2007 from menu DataFrom Text and
in 2003 from menu DataImport External DataImport Data select the .csv file
to be opened and then follow ..the Wizard.

If this post helps click Yes
---------------
Jacob Skaria


"sdawson" wrote:

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?