I have an excel where one column is a date column. The format of the date is long date, but requirement is to make it short date. The manual process that team is following is select the whole column and in Home-> Number section from the drop down select the Short Date.
I am doing the Home-> Number-> Short Date using Send Hot key or Type Into, Alt+hns+Enter.It used to work but now its not working. Not sure why.
What is the other way to do this ?