entering 16 digit number in Excel suffix 0 comes automatically

R

Ravi Mohan Sahay

When I key in beyong 15 digits number in a cell of Excel 2000 or office XP
Excel eats up 16th digit and places a 0 and go-on like that.

Please help me
 
N

Niek Otten

Excel numeric precision is 15 significant digits.
If you don't need to calculate with the number, for example credit card
numbers, make it text by preceding the entry with an apostrophe. The
apostrophe will not show.
Another way is to format the cells as text before entering the numbers.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top