Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
MP440
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
MP440
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default How can i write a fomula?

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   Report Post  
Posted to microsoft.public.excel.newusers
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
MP440
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unprotect a write protected file suzzyq Excel Discussion (Misc queries) 2 June 8th 08 08:22 PM
To copy fomula jojo Excel Worksheet Functions 7 July 21st 05 07:45 PM
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? Daniel Excel Worksheet Functions 1 June 23rd 05 11:38 PM
How do I write formula to compare two values and pull the resulta. Renee Excel Worksheet Functions 1 February 11th 05 01:31 AM
how do i write a formula and keep in in formula form, so it DOESN. norcalchick2207 Excel Discussion (Misc queries) 2 February 4th 05 08:38 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"