Excel displaying values incorrectly

  • Thread starter Thread starter Shaun
  • Start date Start date
S

Shaun

Hi,

I am trying to open this xml file with excel but it isnt displaying the
number correctly:

<?xml version="1.0" ?>
<ps>
<p>
<ASCII>100049052049050054000</ASCII>
</p>
</ps>

In the cell it displays

1.00049E+20

and in the formula bar it displays

100049052049050000000

but neither of these are correct! Can anyone help here please?

Thanks for your advice.
 
Hi Shaun

generally, if you don't want to calculate with the number then you
pre-format the cell as "text" (or type an ' in front of the number) -
however, i don't know how you can do that when opening an xml file.

you can not use a number (as a number) in excel with more than 15 digits.

here's a link to another discussion on the topic
http://tinyurl.com/8vjzs
 
Back
Top