Spreadsheet cell parameters


S

Sarge

I'm trying to complete work on an attempt to save invoices and receipts.
However, some the numbers have twenty (20) digits and I get an abreviated
"entry" similar to the following (n represents a digit): nnnnnnnnE+19. Is
there a parameter that allows me to enter the complete number?
 
Ad

Advertisements

T

trip_to_tokyo

Try this because I think it will help you out (this is in EXCEL 2007):-

1. In cell F 11 put:-

10000000000

2. In cell G 11 put:-

10000000000

3. In cell H 11 put the following formula:-

=(F11*G11)

4. The result of the above formula should be (it is on my screen):-

1E+20

5. Now with your cursor in cell H 11 take the following action:-

- Home group

- Font (click on the arrow in the lower right hand corner)

- Format Cells should launch

- Number tab

- select Number in the Category: box (by clicking on it)

- Changes the Decimal places: to read 30 and then hit OK

6. Cell H 11 should now display the correct number and not:-

1E+20

If my comments have helped please hit Yes.

Thanks.
 
G

Gord Dibben

Since Excel uses only 15 significant digits, a 20 digit number must be
treated as text.

Simply preface the number with an apostrophe when you enter it.

The apostrophe won't be displayed in the cell.


Gord Dibben MS Excel MVP
 
Ad

Advertisements

G

Gord Dibben

How would that help OP with a number like

12345678998765432111

Do you not know about Excel's 15 significant digits limitation?


Gord Dibben MS Excel MVP
 

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

Top