Mar 06 2023 06:03 AM
I want to change the number 28022023 into 28/02/2023 format. Kindly advice how how to do it. The number is actually a transaction date provided from a statement. I want to format it into 28/02/2023 so that I rearrange the whole statement from early to current date.
Mar 06 2023 06:20 AM - edited Mar 06 2023 06:22 AM
Mar 06 2023 06:54 AM
SolutionLet's say the number is in A1:
=DATE(RIGHT(A1,4),MID(A1,3,2),LEFT(A1,2))
Then choose desired cell formatting for date.
Mar 10 2023 09:15 AM
Mar 10 2023 09:46 AM
Mar 10 2023 10:15 AM
Mar 10 2023 10:56 PM
Apr 14 2023 03:57 PM
what if the date is like this 1302023 = 1/30/2023 and then the next line is 12252022 = 12/25/2022 ?@vivienkong
Mar 06 2023 06:54 AM
SolutionLet's say the number is in A1:
=DATE(RIGHT(A1,4),MID(A1,3,2),LEFT(A1,2))
Then choose desired cell formatting for date.