How can i write a fomula?

M

MP440

I am trying to figure out how can i get the answer for 10 to the power of 51
in Excel
 
M

MP440

i've try that and with the cell columns and row #'s but all i get as an
answer is 1E+51
 
P

Peo Sjoblom

Excel has only 15 digits precision

--
Regards,

Peo Sjoblom

(No private emails please)
 
G

gregl

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
 
M

MP440

Thanks to all of you for the help given. I really learned something new
-
Thank You,
MP440
 

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

Top