more than 15 digit problem

[pradyuthal]

When I enter more than 15 digit figure the last digit is shown as 0 such 1059104000014252 is shown as 105910400014250. Please provide me with the useful solution.

Thanks a lot in anticipation.

 

[VoG]

Excel will only display a number to 15 digits.

Try formatting the cells as Text before entering the data, or precede the number with '