Text & General Format to Data Format all the data - code/VBA required

[Vishaal]

Hi all,

we have the following data and want to convert in "date", we have tried
Code 1 =TEXT(A1,"mm\/dd\/yyyy")+0
Code 2 =TEXT(G12,"mm/dd/yyyy")

but problem not solved, pls check the result after using the above code and provide the code/vba, also when we copy the data after using code 1, we cant get the value as data

Data

Excel 2010 32 bit

	A​	B​	C​
1​	its my format which I want to change in date format	​	​
2​	Date​	​	​
3​	01-04-2019​	=TEXT(A3,"mm\/dd\/yyyy")+0​	=TEXT(A3,"mm/dd/yyyy")​
4​	02-04-2019​	=TEXT(A4,"mm\/dd\/yyyy")+0​	=TEXT(A4,"mm/dd/yyyy")​
5​	02-04-2019​	=TEXT(A5,"mm\/dd\/yyyy")+0​	=TEXT(A5,"mm/dd/yyyy")​
6​	04-04-2019​	=TEXT(A6,"mm\/dd\/yyyy")+0​	=TEXT(A6,"mm/dd/yyyy")​
7​	05-04-2019​	=TEXT(A7,"mm\/dd\/yyyy")+0​	=TEXT(A7,"mm/dd/yyyy")​
8​	06-04-2019​	=TEXT(A8,"mm\/dd\/yyyy")+0​	=TEXT(A8,"mm/dd/yyyy")​
9​	24-09-2019​	=TEXT(A9,"mm\/dd\/yyyy")+0​	=TEXT(A9,"mm/dd/yyyy")​
10​	4/5/2019​	=TEXT(A10,"mm\/dd\/yyyy")+0​	=TEXT(A10,"mm/dd/yyyy")​
11​	4/9/2019​	=TEXT(A11,"mm\/dd\/yyyy")+0​	=TEXT(A11,"mm/dd/yyyy")​
12​	4/17/2019​	=TEXT(A12,"mm\/dd\/yyyy")+0​	=TEXT(A12,"mm/dd/yyyy")​
13​	4/26/2019​	=TEXT(A13,"mm\/dd\/yyyy")+0​	=TEXT(A13,"mm/dd/yyyy")​
14​	5/4/2019​	=TEXT(A14,"mm\/dd\/yyyy")+0​	=TEXT(A14,"mm/dd/yyyy")​
15​	5/4/2019​	=TEXT(A15,"mm\/dd\/yyyy")+0​	=TEXT(A15,"mm/dd/yyyy")​
16​	5/21/2019​	=TEXT(A16,"mm\/dd\/yyyy")+0​	=TEXT(A16,"mm/dd/yyyy")​
17​	20-07-2019​	=TEXT(A17,"mm\/dd\/yyyy")+0​	=TEXT(A17,"mm/dd/yyyy")​
18​	06/08/19​	=TEXT(A18,"mm\/dd\/yyyy")+0​	=TEXT(A18,"mm/dd/yyyy")​
19​	24-07-2019​	=TEXT(A19,"mm\/dd\/yyyy")+0​	=TEXT(A19,"mm/dd/yyyy")​
20​	26/09/2019​	=TEXT(A20,"mm\/dd\/yyyy")+0​	=TEXT(A20,"mm/dd/yyyy")​

Sheet: Sheet1

Result Data
Excel 2010 32 bit

	A​	B​	C​
1​	its my format which I want to change in date format	​	​
2​	Date​	​	​
3​	01-04-2019​	01-04-2019​	04/01/2019​
4​	02-04-2019​	02-04-2019​	04/02/2019​
5​	02-04-2019​	02-04-2019​	04/02/2019​
6​	04-04-2019​	04-04-2019​	04/04/2019​
7​	05-04-2019​	05-04-2019​	04/05/2019​
8​	06-04-2019​	06-04-2019​	04/06/2019​
9​	24-09-2019​	24-09-2019​	09/24/2019​
10​	4/5/2019​	05-04-2019​	04/05/2019​
11​	4/9/2019​	09-04-2019​	04/09/2019​
12​	4/17/2019​	17-04-2019​	04/17/2019​
13​	4/26/2019​	26-04-2019​	04/26/2019​
14​	5/4/2019​	04-05-2019​	05/04/2019​
15​	5/4/2019​	04-05-2019​	05/04/2019​
16​	5/21/2019​	21-05-2019​	05/21/2019​
17​	20-07-2019​	#VALUE!​	20-07-2019​
18​	06/08/19​	08-06-2019​	06/08/2019​
19​	24-07-2019​	#VALUE!​	24-07-2019​
20​	26/09/2019​	26-09-2019​	09/26/2019​

Sheet: Sheet1

 

[footoo]

1. DD-MM-YYYY
2. DD/MM/YYYY
3. Some cells are General

This is not like the data you posted.
For example :
24-9-2019 (is it DD-M-YYYY or D-M-YYYY?)
4/5/2019 (is it D/M/YYYY or M/D/YYYY?)
4/17/2019 (is it M/DD/YYYY or M/D/YYYY?)
Are these examples text or dates?

 

[footoo]

Maybe this : =IF(ISNUMBER(A3),A3,DATEVALUE(A3))

 

[Vishaal]

Thanks footoo,

thanks for giving time and help