.csv files and Scientific number display

G

Guest

When opening a .csv file in Excel that contains phone numbers, all the phone numbers are displayed in Scientific notation. The problem is that I need to select those columns, and choose format cells, numbers and set the decimal place to zero before saving the file again. If I do not perform the above step, the numbers lose the last few significant digits. E.g. 44778756789 is saved as 44778750000. Is there a way to set Excel preferences to not display any numbers with Scientific notation when opening such a file

Thank you
 
D

Dave Peterson

If you rename your .csv file to .txt, then when you open it, you can specify
that this field should be treated as text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Hex numbers displayed in scientific notation when importing text f 2
CSV to Excel 3
Import large number string 1
CSV text data altered on file open 4
how can I save an excel file with long number columns in cvs form. 3
CSV and Custom Fields 6
how to resolve incompatibility of saving an excel to csv format 1

Top