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