View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default large number in cell

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.
--
David Biddulph

"Carlos Cardona" <Carlos wrote in message
...
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.