Excel Conditional Formatting (START to FINISH!)

[@abstractioncircles1166]

well done, very detailed and extensive guide !!

[@ExcelArtista]

Thank you!

[@Kevin-g3g1v]

Thanks for your powerful knowledge .
I use an Excel file including 20 or more sheets to download from internet, some stock data, like date, open, high, low, close, volume. Problem is Number Stored in Text. I have to convert each sheet into Number. You must have some great ideas to fix it, do you?

[@ExcelArtista]

Excel making numbers behave like text? It's like trying to teach a cat to swim! But I have some ideas.
1. Automate the process using macros/VBA, but it requires basic VBA knowledge. However with that you can personalize it 100%.
2. Use 'Replace' (but not sure if it works)
🔸Select all sheets
🔸Press 'Ctrl' + 'H' to open 'Find and Replace' window
🔸On 'Find what' leave the box empty and on the right side, click 'Format' and choose 'Text'
🔸On 'Replace with' leave the box empty and on the right side, click 'Format' and choose 'Number'
🔸Click 'Replace All'
Instead of values, this is supposed to replace formats.
I Hope it helps

[@Kevin-g3g1v]

Thank you so much. I also find a formula =VALUE(TRIM(CLEAN(B2)))@@ExcelArtista

[@ExcelArtista]

@@Kevin-g3g1v That's indeed a very good alternative I didn't know about and it works perfectly, well done!

[@Kevin-g3g1v]

@@ExcelArtista

[@ragulmarley4900]

Data set link

[@Kevin-g3g1v]

Find it. =VALUE(TRIM(CLEAN(B2)))