Date and time format Conversion

[Npatel1906]

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

[#2]

@Npatel1906 

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.

[#3]

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?

[#4]

@Npatel1906 

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

[#5]

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