Hi Experts
I have issue in date format where formula not support
column A:A entired colu
29/03/2021 i want change as 03/29/2021
30/09/2022 i want change as 09/30/2022
30/04/2021 i want change as 04/30/2021
28/04/2021 i want change as 04/28/2021
14/04/2021 i want change as 04/14/2021
21/03/2023 i want change as 03/21/2023
21/03/2023 i want change as 03/21/2023
03-Jun-20 look like this
Do you still need VBA if formula can do it?
Are dates real date, or text string?
Have you tried to format column A as "mm/dd/yyyy"?
If yes, and if format does not changed, try in B1:
=DATE(RIGHT(A1,4)+0,MID(A1,4,2)+0,LEFT(A4,2)+0)
Drag down then copy column B, then paste value back to column A, then format again.
If it still does not work, try to attach a sample worksheet.
Quang PT
Hi boss
its work when change manually if i use formula it give some
28/10/2019 09:00:00 if i use formula come like this 10/28/1900
i have date like this 28/10/2019 09:00:00
21/10/2022 17:02:31
14/01/2020 10:47:02
24/04/2023 18:00:00
18/05/2020 16:54:05
26/03/2019 15:37:21
18/10/2022 10:59:28
want to change as cell look like that 28-Oct-19 but inside 10/28/2019 9:00:00 AM
Last edited by breadwinner; 03-02-2023 at 12:34 AM.
Pls attach a sample worksheet.
Try this formula in B1 copied down
=DATE(MID(A1,7,4)+0,MID(A1,4,2)+0,LEFT(A1,2)+0)+(Right(A1,8)+0)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks