17 digit number

T

Té

I'm trying to enter customer's number which consists of 17 or 18 digits.
When I enter the number it keeps giving me zeros after. How can I get rid of
the zeros? The number I enter 15468597568563215 and after this number I get
four or five zeros.
 
R

Rick Rothstein \(MVP - VB\)

Type the number in with a leading apostrophe so that it will be considered
text and not a number (the apostrophe won't show up in the cell). Hence,
enter your number this way...

'15468597568563215

Rick
 
D

David Biddulph

Excel's numbers have a precision of 15 digits. If you want more than that,
enter as text (either format the cell before you enter the data, or precede
the data with an apostrophe), but you can't do arithmetic with text.
 
Top