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?

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?

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?

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