godzooky

take the .csv from the file extension and Excel will invoke the text import
wizard. mark this column as text in the wizard.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"godzooky" wrote in
message ...

i am generating a csv file that i'm importing to excel. one field is
string of numbers, which i need to display exactly as it is in csv
file. for example, if 2777380003, is in the csv file, i want to see
that exact same string in excel, not scientific notation which seems to
be the default. i tried adding a single quote in the csv file, like
this, '2777380003, but the single quote is displayed in excel until i
double click the cell. is there a way to denote no formatting inside a
csv file?

thanks


--
godzooky
------------------------------------------------------------------------
godzooky's Profile:
http://www.excelforum.com/member.php...o&userid=32424
View this thread: http://www.excelforum.com/showthread...hreadid=521911