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
 

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

Back
Top