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?

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?

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?

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

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