20 digit number

  • Thread starter Thread starter belitre
  • Start date Start date
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.
 
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).
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

format cell with multiple formats for telephone numbers 1
Number in text format in CSV file 3
Extract number from text string based on number's format? 16
16 digit numbers 2
12 digit number rounding down why? 5
Maximum amount of numbers in one Cell 2
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
change ten digits in a cell to include phone # formats 5

Back
Top