| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding?
When I enter a 16 digit credit card number, excel rounds the last digit to 0;
How do I format to reatin the exact number I entered (Have formatted cells to numbers, no decimal places now.) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel rounding my 16/17 digit numbers | Excel Worksheet Functions | |||
| How to enter more than 20 digit numbers in one cell | Excel Discussion (Misc queries) | |||
| Entering 16 digit numbers in cell | New Users to Excel | |||
| Rounding off numbers in Excel 2003 | Excel Worksheet Functions | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
Threaded Mode
