How to Convert Scientific Notation to Numbers

[rebel123]

Anyone have an equals sign answer for this for a drag-down formula?
Correct answers are in green. Thanks!

And here is the file-

easyupload.io

easyupload.io

easyupload.io

 

[rebel123]

I found the answer. Sorry-

Excel Will Not Post Long Numbers- They are Shortened by +16 and +17

Excel Will Not Post Long Numbers- They are Shortened by +16 and +17. I am using Google Sheets. The number is 11120000000000300 and I can only see that number when I hover my mouse, but the excel sheet reads "1.112E+16" So how do I change that for all of the rows? I can drag down the formula, so...

www.mrexcel.com

If you want me to delete the post- I would but do not know how to do so.

Thanks!

 

[smozgur]

And the answer is also your own question from 2020!

If you want me to delete the post- I would but do not know how to do so.

No need to delete the post (and you can't delete a post on the board anyway). However, perhaps you might consider marking the solution post in the referred question as well. (Thanks for marking solutions in your threads by the way, it is really helpful for future readers.)

Note: I only edited the title of this question to be more specific about scientific notation, so it will also help future readers.

 

[Jimmywick]

Select the cells that you want to format.
On the Home tab, click the small More button.
In the Category list, click Scientific.
Using the small arrows, specify the Decimal places that you want to display.

Greetings,
J Wick