large number in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to import an XML file to excel an it has a very large number (21
digits), but the last 6 digits ar zero and they shouldnt be... i try to
change the cell to all formats but i dont get my last 6 digits... the
problem is posted at the community, but there is not a succesfull answer.
 
You will need to format as text before you import the values, as Excel will
not deal with more than 15 significant digits in number formats.
 
Still doesn't work.

I do right clic on my xml file and open it with excel, appears a little
window with 3 options, i pick the number 3 ( Use Source XML task panel -I
translated it from spanish- ). Exclel creates a schema. I asign fields to
columns, then change all cells format to text, then import the data from my
xml file but doesn't work... i get the exponential number... when i edit the
cell it changes to the large number but the last digits are zeros. The only
place i see my complete number is the task panel... when i change the option
to see an example of data in front of each field.
 

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