Date and time format Conversion

Copper Contributor

"How can I change the time format from 10.10.2023 03:28 to 10/10/2023 03:28 AM in Excel?"

4 Replies


Unfortunately, 10/10 is ambiguous.

Apply the number format mm/dd/yyyy hh:mm AM/PM or dd/mm/yyyy hh:mm AM/PM to the cells, depending on your system date format.

Hi Hans Vogelaar,
I did apply same custom formula to the column, however, existing data was not changed.
Is there any way that i can change the existing data?


What happens if you select a column with such values and use the Replace dialog (Ctrl+H) to replace . with /  ?

It worked along with dd/mm/yyyy hh:mm AM/PM customization.
Thank you for your help.