Spreadsheet cell parameters
 

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?
--
Thanx 4 the help,
Sarge

Spreadsheet cell parameters
 

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.



"Sarge" wrote:

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?
--
Thanx 4 the help,
Sarge

Spreadsheet cell parameters
 

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

On Fri, 18 Dec 2009 14:50:02 -0800, Sarge
wrote:

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?

Spreadsheet cell parameters
 

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

On Sat, 19 Dec 2009 01:14:01 -0800, trip_to_tokyo
wrote:

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.



"Sarge" wrote:

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?
--
Thanx 4 the help,
Sarge