17 digit number

  • Thread starter Thread starter Té
  • Start date Start date
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.
 
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
 
Back
Top