Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
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
Result Data
Excel 2010 32 bit
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 |
Last edited: