View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Excel is rounding off more than 16 digits ?

Excel is limited to 15 digits of precision -- anything beyond that is
rounded. This is based on the industry standard Floating Point
Specification, and occurs in most software, not just Excel. If you don't
need to do math with the numbers, you can precede the number with an
apostrophe ('). This will not show in the cell but will show in the formula
bar. Of course, if you try to do math with the numbers, you'll have rounding
problems. See www.cpearson.com/Excel/Rounding.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Vijay Kotian" wrote in message
...
I have encountered an unique problem, wherein, while opening a file where
more than 16 digits are there, excel automatically converts digits to 0
after
16th digits. Can anyone help me out to resolve this issue.

e.g. if my number is 20071022123456789 it is automatically converts to
20071022123456700, last two digits 89 is automatically takes it as 00.

How is it possible to take full number ........ 20071022123456789 ?

Thank you.