| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many number digits can I fit into one cell?
I'm currently trying to produce a membership report for my clients and every
member has a membership number of 18 digits. When I type the membership number into excel (2003) it seems to round-up the last three didgits, for example, a membership number which is 647895124848598745 will be displayed as 647895124848598000. Can anyone help me with this? I've tryed doing all sorts of different formatting etc but can't seem to solve it. If there is a limit on how many digits I can use in one cell, is there any other way to increase this limit? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of digits in a cell | Excel Worksheet Functions | |||
| deleting the first 2 digits of number in a cell | Excel Worksheet Functions | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| Reducing the number of digits in a cell | Excel Discussion (Misc queries) | |||
| calculate using last four digits of number in cell | Excel Worksheet Functions | |||
Threaded Mode
