How can i write a fomula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to figure out how can i get the answer for 10 to the power of 51
in Excel
 
i've try that and with the cell columns and row #'s but all i get as an
answer is 1E+51
 
Excel has only 15 digits precision

--
Regards,

Peo Sjoblom

(No private emails please)
 
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:

1000000000000000000000000000000000000000000000000000


Good Luck,

Greg
 
Thanks to all of you for the help given. I really learned something new
-
Thank You,
MP440
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can anyone provide me the fomula ? 1
Dates in fomula showing as whole number 10
Format for Time Elapsed in Decimal 4
Copy/Fill Down in increments 1
AND formula 2
got #REF! with fomula PRICE() 2
enter figures in timesheets and it updates a job costing sheet 4
Using same fomula to count AND and OR options / sumproduct 5

Back
Top