data truncates when converting .csv to .xls

[Guest]

I receive every day an e-mail with a file with data in .csv format.
When opening this file as a .xls, a specific field with a 20 digit value,
gets truncated and last 5 digits appear as Cero.
(of course they were not Cero in the original .csv file)
in summary:
"23848730987391234598" is converted to --> "23848730987391200000"

can someone help?
than you

 

[Norman Jones]

Hi Sergio,

Try renaming the csv fie as a txt file. Then, when you open the renamed file
in Excel, rhe Data Import Wizard will be invoked. The wizard will enable you
to define the numeric field as text and all the digits will be displayed.

 

[Dave Peterson]

When you double click on that .csv file, you don't have any control over how
excel sees your data.

And excel will see that field as numeric and treat it that way. The bad news is
that excel only keeps track of up to 15 digits when dealing with numbers.

Try saving that attachment on my harddrive somewhere as .txt (not .csv).

Then open excel and do
File|Open (that .txt file)

You'll see the data import wizard pop up and you'll be able to specify Text for
this long numeric field. And as text, excel will keep all the digits as-is.

 

[Dave Peterson]

Please don't try this:

Try saving that attachment on my harddrive somewhere as .txt (not .csv).

But it's ok to save the attachment on YOUR harddrive!

 

[Earl Kiosterud]

Hey Dave, I got lots of stuff I'd like to store on your drive.

Earl Kiosterud
www.smokeylake.

 

[Dave Peterson]

You and Sony/BMG????

Hey Dave, I got lots of stuff I'd like to store on your drive.

Earl Kiosterud
www.smokeylake.