Display a 16 digit number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you enter a 16 digit number without adding extra numbers on the end or
displaying a formula? I have tried all the Format Cells options with no luck.
Many Thanks!
 
Excel can cope with 15 digits.
Assuming your 'number' is something like a bank account number and no math
will be done on the number: type an apostrophe before entering the number;
e.g. '1234567887654321
 
Format your cell as text or put an anpostrophe in front of your
numbers.

i.e
'12345678912345678

Regards
JG
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Format on 16 Digit Number 5
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
How to restrict zeros in a number from 16th digit onwards 5
Number of significant digits allowed in a cell is 15. 2
16 digit numbers 2
16 digit number entry changes last digit to 0 1
how to write 1234567890123456789 into a cell with number format 3
How do you display 16 digit numbers in excel ? (it keeps convert. 3

Back
Top