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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many number digits can I fit into one cell?
Numbers more than 15 will be displayed as 000.
Preformat the cell to Text and enter OR Prefix the entry with a single quote '123456789012345678 If this post helps click Yes --------------- Jacob Skaria "HoppoM" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many number digits can I fit into one cell?
Format the cell as Text or enter a single quote sign before the membership
number to treat the number as text. Hopes this helps. .... Per "HoppoM" skrev i meddelelsen ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many number digits can I fit into one cell?
On Jul 9, 2:18*pm, Jacob Skaria
wrote: Numbers more than 15 will be displayed as 000. Preformat the cell to Text and enter OR Prefix the entry with a single quote '123456789012345678 If this post helps click Yes --------------- Jacob Skaria "HoppoM" wrote: 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?- Hide quoted text - - Show quoted text - yes it work....thx alot with this helpful answer Godwin |
Reply |
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 |