A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Spreadsheet cell parameters



 
 
Thread Tools Display Modes
  #1  
Old December 18th, 2009, 11:50 PM posted to microsoft.public.excel.setup
Sarge
external usenet poster
 
Posts: 10
Default 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
  #2  
Old December 19th, 2009, 10:14 AM posted to microsoft.public.excel.setup
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default 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

  #3  
Old December 19th, 2009, 10:38 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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?


  #4  
Old December 19th, 2009, 10:48 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.