Importing data numbers

J

JB

I'm having a problem when inmporting numbers into excel from a text file.
I'm finding that excel is concverting the number into a scientific format,
which once imported I cant convert back.
Is tehre any way of changing a setting so that the numbers dont get truncated?
 
K

Kevin B

Open the text file from Excel and and when defining the columns to import
designate of large numbers as text.
 
D

David Biddulph

Or import your csv by Data/ Import External Data, rather than by File/ Open.
 

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
CSV to Excel 3
how can I save an excel file with long number columns in cvs form. 3
Hex numbers displayed in scientific notation when importing text f 2
Excel 2003 - Importing External Data - formatting problem? 2
Format 1
Sorting data with the letter 'E' included 3
Changing Text To Numbers ? 1

Top