Forum Discussion

Npatel1906's avatar
Npatel1906
Copper Contributor
Nov 08, 2023

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?"
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Nov 08, 2023

Npatel1906 

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

Npatel19061390's avatar
Npatel19061390
Copper Contributor
Nov 09, 2023
HansVogelaar,
It worked along with dd/mm/yyyy hh:mm AM/PM customization.
Thank you for your help.

Resources