Excel Macro to Convert Number Format into 'Comma Style' accross All Worksheets

Hi excelforum Experts,

I have this excel data exported from the system that contains 'Number Stored as Text". I tried recording a code for these but the code did not work entirely, there are still numbers which have 'green color' on the upper-left of the cell. Could someone help me this out?

I have attached the sample workbook that I am referring to and I wish to convert all numbers from 'Range B8:H500' to be converted into 'Comma Style' for all worksheets (Sometimes I have about 31 worksheets in a workbook).

Thank you in advance!


Warmest regards,
Arbel

Hi FDibbins,

I want my process to be automated because I have 30 workbooks which have about 31 worksheets. It would be much appreciated if you could help me create VBA code to automate this process.

Thank you in advance!


Warmest regards,
Arnel

Hi leelnich,

It works like magic!

Thanks for providing me with the best VBA codes that exceeded my expectation. This will enable me to save time processing data in excel.

I appreciate your immediate feedback. Have a great day!


Warmest regards,
Arnel