How to remove zero's appearing at the end of number

Question

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:

Answer 1

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.