Hello guys,
I got date format from third party program like in the below pictures.
2023 = years
03 = month
22 = date
01 = hours time
13 = minute
50 = secs
I have tried to change date format to Short format, Custom format. But it always show like in the Cell A1.
Could you help me to change date format and separate them with date and time into 2 cells?
Thanks,
I got date format from third party program like in the below pictures.
2023 = years
03 = month
22 = date
01 = hours time
13 = minute
50 = secs
I have tried to change date format to Short format, Custom format. But it always show like in the Cell A1.
Could you help me to change date format and separate them with date and time into 2 cells?
Thanks,