Forum Discussion
date formatting
I have a file with date looks like Jul 13, 2022, 5:00:00 PM and would like to change them to 7/13/2022 17:00 but format cell doesn't work. How do I do that?
you can put the date into a different cell and have that new cell force a format using formulas. say your date cell is A5, the formula in B5 would be =TEXT(A5,"mm/dd/yyyy hh:mm"). this should force the format without using the format in your Excel settings