I image you are entering things like social security or credit card
"numbers" on which no math will ever be done. Two tricks to avoid your
problem
1) type a single quote (apostrophe) before entering the number - it will not
show on spreadsheet or on hardcopy
OR
2) Before entering the number, format the cells to be used as Text
Reason: like most computer apps, Excel uses the IEEE convention for storing
numbers and this limits numbers to 15 sig figs (still big enough for the US
national debt but don't hold your breath!)
The limit for true numbers is 15 digits. Anything you type after that is
converted to 0. Assuming you don't want to do math on this number, format the
column as text before you start to enter the data, or type an apostrophe
before the 1st digit. The entry will now be text, not a number
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.
