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.
 
Top