| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
16 digit number entry changes last digit to 0
When I enter a 16 digit number on a 2004 excel for Mac spread sheet, the l6th
digit changes to 0 no matter what it was that I typed. I can enter a 15 digit number with no changes. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
16 digit number entry changes last digit to 0
Excel only keeps track of 15 significant digits.
If you can treat the entry as text, then you can preformat the cell as Text, then do the data entry or you can start your entry with an apostrophe: '1234123412341234 Donald T wrote: When I enter a 16 digit number on a 2004 excel for Mac spread sheet, the l6th digit changes to 0 no matter what it was that I typed. I can enter a 15 digit number with no changes. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| Sorting a six digit number by terminal digit | Excel Worksheet Functions | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| How do I identify the 7th digit in a 13 digit number, then establi | Excel Worksheet Functions | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Linear Mode
