Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Excel has only 15 digits precision
-- Regards, Peo Sjoblom (No private emails please) "MP440" wrote in message ... 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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
unprotect a write protected file | Excel Discussion (Misc queries) | |||
To copy fomula | Excel Worksheet Functions | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
How do I write formula to compare two values and pull the resulta. | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) |