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