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
|