0

Using Microsoft Office Excel 2007, I have to insert the numbers of more than 15 digits in a cell. But I have a problem inserting the complete number because the cell is automatically displaying zero's after 15 digits:

enter image description here

pnuts
  • 58,317
  • 11
  • 87
  • 139
MAK
  • 6,824
  • 25
  • 74
  • 131
  • The reason is the limited precision that can be stored in floating point numbers. [see this answer](http://stackoverflow.com/a/7330887/445425) – chris neilsen Oct 01 '15 at 05:11

1 Answers1

2

Excel uses 15 significant digits in calculation so, logically, it can't display more than that - any digits beyond the 15th will be displayed as zero.

Mark Fitzgerald
  • 3,048
  • 3
  • 24
  • 29