Number is changed when importing XML file into excel 2007

D

DanielWP

While importing a xml file into excel 2007, numbers that are longer than 15
digits are changed.

a number like 571515179100191702 is displayed in an excel cell as
5,71515E+17 and the underlying number is 571515179100192000. For some reason
the last 3 digits are rounded off, and replaced by zero's.

Does anybody know which settings can be changed in order to allow the
correct numbers to be imported into excel?

Best regards
Daniel
 
B

Bob Greenblatt

Excel can only use 15 significant digits. If these are really numbers,
you'll have to accept the round off, or find some other application to use
them. If they are not really numbers (values) but stock numbers or something
similar, then precede the number with an apostrophe, and it will be treated
as text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Excel file into Word Document 3
Importing XML Data in Access 2003 1
Importing a large .XML file into Excel 2003 0
Converting a number (17 characters) to text (Scientific Notation) 4
Excel is converting my alphanumeric text to scientific notation 2
Importing xml file to excel 2
Numbers changed into zeros 6
digits being added on importing 5

Top