Hi everyone, first post so I hope somebody can answer this one...
I have a csv file where one of the fields is a long number, for example 990737587638. When I open the csv in Excel 2000 (and also in some later versions I have tried this on) the number displays as 9.90738E+11. My thoughts were that I just needed to format the sheet as text and save it somehow before opening the csv file but I can't figure out how to do it.
What can I do to save my default spreadsheet as text so that these numbers appear as 12 digit text strings on opening or am I trying to do this the wrong way?
Thanks in advance.
Bookmarks