Excel does not allow more than 15 digits

I noticed today that Excel does not allow more than 15 digits in a cell. If you a type a number with more than 15 digits into an excel cell, the digits after the first 15 get replaced by zeroes. I had a hard time trying to figure out how to fix this. You can make the cell accept more than 15 digits by:
[1] pre-formatting the cells as text fields BEFORE pasting the values
[2] by start the number with an apostrophe i.e. ‘
From Microsoft Knowledge Base 269370:

Excel follows the IEEE 754 specification on how to store and calculate floating-point numbers. Excel therefore stores only 15 significant digits in a number, and changes digits after the fifteenth place to zeroes.
To work around this behavior, format the cell as text. The cell can then display up to 1,024 characters.”

Related Links:


New lines in an Excel cell

I just figured out how to enter a new line in an Excel cell. The trick is to use Alt+Enter to create a new line. Also, when you do that, Excel automatically enables text wrap for the cell.
Windows: Alt+Enter
Mac: Hold down apple key + Option + Enter
(Thanks to Tex and Andy for the Mac tip)
Tips List
Alt+Enter: Enter new line in a cell
F2: Edit a cell
Originally posted: 2005-05-02
Last updated: 2011-01-13