0

I am facing a small issue with excel. I have a worksheet that I want to use as adding a large number value but when I am entering a large number its changes to a different value format. Let me show you, please.

enter image description here

My question is how I can get the cell values like in Column D and sum them all. Please help me. Thanks

shakeel ahmad
  • 73
  • 8
  • This is happening because Numeric precision limitation in Excel. Excel can show up to 15 significant digits. Read more [here](https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel#:~:text=Although%20Excel%20can%20display%2030,%2C%20truncation%2C%20and%20binary%20storage.). – shrivallabha.redij Dec 28 '20 at 11:09
  • If you can find online the `xNumbers` add-in for Excel, it can handle greater precision than native Excel. If you cannot find that or something similar, you will need to write your own VBA tool, or use a different program. – Ron Rosenfeld Dec 28 '20 at 12:04

0 Answers0