| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Making a list of numbers with 16 digits
When I enter the numbers, excel makes the last digit zero. for example:
5476480060834825 would be shown as 5476480060834820 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making a list of numbers with 16 digits
Precede the entry with an apostrophe ' or format as text BEFORE you enter
the numbers, Excel has only 15 digits of precision anything after that will be truncated. I am sure you don't need to do calculations on these numbers, sounds more like you need to store account/credit card numbers and if that's the case you can simply use my suggestion -- Regards, Peo Sjoblom "Melinda" wrote in message ... When I enter the numbers, excel makes the last digit zero. for example: 5476480060834825 would be shown as 5476480060834820 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a list of discrete numbers (names?) and occurences of each | New Users to Excel | |||
| Formulas-Making a number a standard amount of digits | Excel Discussion (Misc queries) | |||
| How do I display numbers of 12 digits or more? | Excel Discussion (Misc queries) | |||
| Sorting numbers with differing numbers of digits | Excel Discussion (Misc queries) | |||
| making a list of numbers. | Excel Discussion (Misc queries) | |||
Hybrid Mode
