Spreadsheet cell parameters

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

 

[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.

 

[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

 

[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