How many number digits can I fit into one cell?

  • Thread starter Thread starter HoppoM
  • Start date Start date
H

HoppoM

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?
 
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
 
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
 
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





- Show quoted text -
Click to expand...

yes it work....thx alot with this helpful answer Godwin
 
Back
Top