20 digit number

B

belitre

I need to put an invoice number with the following format:

#### #### ## ##########

I have to use just 1 celd.
The problem is that Excel 2000 just takes the first 15 digits and
truncates to 0 the rest.
For instance:

Number introduced: 12347890123478961234
Number showed: 1234 7890 12 3478900000

Can someone solve this? Thank you very much.

Regards.
 
A

Andy Wiggins

Excel can only handle figures upto 15 digits.

You will need to input the number as text. Either format the cell as text,
or precede the entry with an ' (apostrophe).
 
C

cvolkert

Not sure if this works for you, but if you format as text, you should b
able to fit the entire figure. If it has to be a number, I'm not sur
off the top of my head. Later, Cha
 
Top