| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data numbers
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing data numbers
Open the text file from Excel and and when defining the columns to import
designate of large numbers as text. -- Kevin Backmann "JB" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing data numbers
HI kevin, thanks for that.
I actually note its a csv file will that work the same? "Kevin B" wrote: Open the text file from Excel and and when defining the columns to import designate of large numbers as text. -- Kevin Backmann "JB" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing data numbers
Rename the .csv file to .txt first.
JB wrote: HI kevin, thanks for that. I actually note its a csv file will that work the same? "Kevin B" wrote: Open the text file from Excel and and when defining the columns to import designate of large numbers as text. -- Kevin Backmann "JB" wrote: 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? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing data numbers
Or import your csv by Data/ Import External Data, rather than by File/ Open.
-- David Biddulph "Dave Peterson" wrote in message ... Rename the .csv file to .txt first. JB wrote: HI kevin, thanks for that. I actually note its a csv file will that work the same? "Kevin B" wrote: Open the text file from Excel and and when defining the columns to import designate of large numbers as text. -- Kevin Backmann "JB" wrote: 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? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing numbers as text | Excel Discussion (Misc queries) | |||
| importing numbers from html-charts | Charts and Charting in Excel | |||
| Importing long numbers from CSV file | Excel Discussion (Misc queries) | |||
| Retain Numbers as Text Format When Importing. | Excel Discussion (Misc queries) | |||
| Importing text files to Excel with big numbers | Excel Worksheet Functions | |||
Linear Mode
