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.

Leading zeros	Normal	E+ signs	Reference	Functions	date	Broken	Arabic	dr	cr	Floating
000000032131324	11	1.11E+07	000000032131324	11111100	1/20/2022	1232 fdsdsfdsfds fdasd	بنتيسكمنتبمنيسشي	325325.5746	4324.4643	ask;jdk;ajsd;"dkorwe"dokjad
00000123	11	1.11E+07	00000123	11111100	1/21/2022	fds	منسشىب	3524562.4330	23563.4500	"aswopekmfksad"sad,'ds
00000123	11	1.11E+07	00000123	11111100	3/22/2022		يشسيصضخهتبى	3524562.4330	23563.4500	ask;jdk;ajsd;"dkorwe"dokjad
00000123	321	1.11E+07	00000123	11110790	12/23/2022	fds	ىرنتي رنتشسي	3524562.4330	23563.4500	"aswopekmfksad"sad,'ds
00000123	11	1.11E+07	00000123	11111100	1/1/2022	sa 123213213214214	سشمىبيتىلنتيس	3524562.4330	23563.4500	ask;jdk;ajsd;"dkorwe" dokjad
00000123	321	1.11E+07	00000123	11110790	01/30/2022		هفكنلمةب	3524562.4330	23563.4500	"aswopekmfksad"sad,'ds
00000123	11	1.11E+07	00000123	11111100	01/25/2022	fds	ىستشىي	3524562.4330	23563.4500	ask;jdk;ajsd;"dkorwe"dokjad
00000123	221	1.11E+07	00000123	11110890	01-25-2022		منسشتيص	3524562.4330	23563.4500	"aswopekmfksad"sad,'ds