How to stop Excel from changing decimals to scientific notation?

I just got a new work laptop which uses Microsoft Office 365. I regularly pull in stock prices and currency foreign exchange conversion from Yahoo! Finance into CSV, which I then copy and paste values into my Excel spreadsheet.

One of the items I pull from Yahoo! Finance is IDRSGD=X, which is basically converting Indonesian Rupiah (IDR) to Singapore Dollars (SGD). Now, say IDR 1 = SGD 0.000077 and it is shown as such in Yahoo! Finance. However, in the CSV, the number automatically becomes 7.7E-5. When I copied and pasted from the CSV to my Excel file, it stayed the same way, ie. 7.7E-5. I know they mean the same thing but it's ugly and it just stands out like a sore thumb against all my other data in my spreadsheet, which are nicely presented in decimals. How can I stop Excel from automatically converting this notation? I went to Options --> Data and unchecked the relevant boxes, but it didn't help.

In Excel, even if I Format Cells --> Number to reflect decimals, it does not help either. Somehow the ugly scientific notation overrides the cell formatting. There are many cells in the data set showing scientific notation instead of decimals, and I cannot be going cell by cell.

I never faced this problem with my previous Microsoft Office 2019.

Can someone please help?