I have created a macro using chat gpt to help me save Excel files and clean them as I receive a lot of Excel files.

The problem is I never want to edit the raw data - just clean it. I have attached a test Excel file where it includes the problems that might occur, including broken, floating, E+ signs and referencing and functions. The macro created sometimes converts numbers into dates, doesn't resize the columns and saves them as # and it is really slow.

In addition the numbers need to be formatted with 4 decimals places in order to show the decimals if there are any. It's not mandatory to have them with 4 places, but I just want the full content of the numbers.

Please keep in mind the structure of the files I receive is different each time. I have no experience in VBA, I just used chat gpt. I have tried to ensure no formatting to the dates as well. I would send the files on a drive link as well.