The problem is that Excel thinks it knows what to do because the file is
..csv. If you rename the file to .txt and then open it, Excel will present
the Import Wizard and allow you to define the fields.
--
Gary's Student


"Kevin" wrote:

Hi,
i need to be able to open a .csv file in Excel with large numbers and or
Leading zeros without having to put a ' single quote in or format the column
as text or import using text to columns so that i do not lose the
actual/original data i am passing to Excel - is there anyway to do this or
fool Excel in the .csv file into thinking the number field is a text field -
i have tried inserting a row at the begininng with only text in each column
but Excell still looses leading zeros and chops the ends of the numbers?
thanks
best regards
kevin