Precede with an apostrophe ' or format as text, sounds as you are entering a
credit card number or some sort of account number, excel has only 15 digits
precision so you need text for this
Numbers can only be 15 digits long (no exceptions). You can however enter it
as text by placing an ' (apostrophe) before the number, or formatting the
cell as text before entering the number.
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.