Forum Discussion
Date and time format Conversion
"How can I change the time format from 10.10.2023 03:28 to 10/10/2023 03:28 AM in Excel?"
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 / ?
