Code to convert numbers with error and general into number and date format

[RAJESH1960]

Hello everyone,
Whenever I download this data, I come across this problem each time. As the rows with numbers in column C are showing an error, it is difficult to match them be it vlookup or index match functions in the code. The numbers can be in any of the rows like it may be in the first row or in the middle or end.
As the dates in columns E and P are in the general format, I need them to be converted into data format "dd-mm-yyyy".
I need your help to write a code for these 3 columns, so that I can add this code in the beginning of my code so that I do not face the above problem again and again. Please note that the headings are merged.
Thank you in advance.

format cells in 3 columns with a code.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1
2
3
4
5	1	2					7	8	9	10					15	GSTR-1/IFF/GSTR-5 Filing Date	17	18	19	20	21	22	23	24
6			Invoice number	4	Invoice Date	6					11	12	13	14
7			BCRS22/149		19-04-2022											11-May-22
8			BCRS22/149-Total		19-04-2022											11-May-22
9
10			59		26-04-2022											11-May-22
11			59-Total		26-04-2022											11-May-22
12
13
14			667/22-23		30-04-2022											13-May-22
15			667/22-23-Total		30-04-2022											13-May-22
16
17
18			110		30-04-2022											11-May-22
19			110-Total		30-04-2022											11-May-22
20
21			AD-55		13-04-2022											11-May-22
22			AD-55-Total		13-04-2022											11-May-22
23
24			AD-56		13-04-2022											11-May-22
25			AD-56-Total		13-04-2022											11-May-22
26
27			367/22-23		25-04-2022											10-May-22
28			367/22-23-Total		25-04-2022											10-May-22
29
30			DSL/20200775		30-04-2022											11-May-22
31			DSL/20200775		30-04-2022											11-May-22
32			DSL/20200775-Total		30-04-2022											11-May-22
33
34			525		01-04-2022											10-May-22
35			525-Total		01-04-2022											10-May-22
36
37			DCR15222301741		14-04-2022											11-May-22
38			DCR15222301741-Total		14-04-2022											11-May-22
39
40			DCR15222303736		28-04-2022											11-May-22
41			DCR15222303736-Total		28-04-2022											11-May-22
42
43			201102946		30-04-2022											11-May-22
44			201102946-Total		30-04-2022											11-May-22
45
46			201102947		30-04-2022											11-May-22
47			201102947-Total		30-04-2022											11-May-22
48
49			201102948		30-04-2022											11-May-22
50			201102948-Total		30-04-2022											11-May-22
51
52			201102949		30-04-2022											11-May-22
53			201102949		30-04-2022											11-May-22
54			201102949-Total		30-04-2022											11-May-22
55
56			201102950		30-04-2022											11-May-22
57			201102950-Total		30-04-2022											11-May-22
58
59
60			2107		30-04-2022											09-May-22
61			2107-Total		30-04-2022											09-May-22
62
63			MM013		08-04-2022											10-May-22
64			MM013-Total		08-04-2022											10-May-22
65
66			MM016		08-04-2022											10-May-22
67			MM016-Total		08-04-2022											10-May-22
68
69			6573		26-04-2022											10-May-22
70			6573-Total		26-04-2022											10-May-22
71
72			1287		09-04-2022											09-May-22
73			1287-Total		09-04-2022											09-May-22
74
75			1844		20-04-2022											10-May-22
76			1844-Total		20-04-2022											10-May-22
77
78			PHP2223-14581193		30-04-2022
79			PHP2223-14581193-Total		30-04-2022
B2B

In the xl2BB sheet it is not possible to view the errors in the number so I am sharing the link to the workbook also.
Loading Google Sheets

 

[RAJESH1960]

Loading Google Sheets
This is the right link.