I am trying to convert a column of different excel date formats to one format, and properly autofit row height after - however even if I format cells - custom to 'ddd, mmm dd, yyyy \at h:mm AM/PM' (the format I want), it does not change. Autofit row height also does not work. The sheet and cells are not locked. The row heights in many cases have been manually adjusted.
Solved by A. E. in 20 mins