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
  • 56,678
  • 9
  • 81
  • 133
MAK
  • 6,052
  • 24
  • 69
  • 116
  • 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
  • 2,988
  • 3
  • 22
  • 29