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