Importing data numbers

  • Thread starter Thread starter JB
  • Start date Start date
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?
 
Open the text file from Excel and and when defining the columns to import
designate of large numbers as text.
 
HI kevin, thanks for that.
I actually note its a csv file will that work the same?
 
Or import your csv by Data/ Import External Data, rather than by File/ Open.
 
You must log in or register to reply here.

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
how can I save an excel file with long number columns in cvs form. 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import large number string 1
text converted to scientific notations 3
Number in text format in CSV file 3
Columns formatted As Dates Are Exported as a Number to Text 1
how to resolve incompatibility of saving an excel to csv format 1

Back
Top