|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 8th, 2005, 02:50 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
How can i write a fomula?
I am trying to figure out how can i get the answer for 10 to the power of 51
in Excel -- Thank You, MP440 
|
|
#2
December 8th, 2005, 03:05 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How can i write a fomula?
Try this: =10^51 Does that help? *********** Regards, Ron "MP440" wrote: I am trying to figure out how can i get the answer for 10 to the power of 51 in Excel -- Thank You, MP440
|
|
#3
December 8th, 2005, 03:11 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How can i write a fomula?
i've try that and with the cell columns and row #'s but all i get as an
answer is 1E+51 -- Thank You, MP440 "Ron Coderre" wrote: Try this: =10^51 Does that help? *********** Regards, Ron "MP440" wrote: I am trying to figure out how can i get the answer for 10 to the power of 51 in Excel -- Thank You, MP440
|
|
#4
December 8th, 2005, 03:45 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How can i write a fomula?
Excel has only 15 digits precision
-- Regards, Peo Sjoblom (No private emails please) "MP440" wrote in message news  i've try that and with the cell columns and row #'s but all i get as an answer is 1E+51 -- Thank You, MP440 "Ron Coderre" wrote: Try this: =10^51 Does that help? *********** Regards, Ron "MP440" wrote: I am trying to figure out how can i get the answer for 10 to the power of 51 in Excel -- Thank You, MP440
|
|
#5
December 8th, 2005, 05:33 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How can i write a fomula?
i've try that and with the cell columns and row #'s but all i get as an answer is 1E+51
Hi MP440, Right-click the cell, choose Format Cells, and then in the Category listbox choose Number. Change decimal places to 0 if desired. Click okay. Widen the column until you see: 10000000000000000000000000000000000000000000000000 00 Good Luck, Greg
|
|
#6
December 11th, 2005, 02:37 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How can i write a fomula?
Thanks to all of you for the help given. I really learned something new
- Thank You, MP440 "MP440" wrote: I am trying to figure out how can i get the answer for 10 to the power of 51 in Excel -- Thank You, MP440
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how do i write a formula and keep in in formula form, so it DOESN. | norcalchick2207 | General Discussion | 2 | February 4th, 2005 08:38 PM |
| Help: starting to write PowerPoint macros | Jim Rambo | Powerpoint | 2 | January 31st, 2005 06:47 PM |
| write conflict? | Zlatko | General Discussion | 0 | December 10th, 2004 08:05 AM |
| write in chinese | BilSlater | Setup, Installing & Configuration | 1 | November 24th, 2004 05:29 AM |
| how can I write in spanish with spelling and grammar checking | Cindy M -WordMVP- | General Discussion | 0 | November 9th, 2004 11:11 AM |
Linear Mode
