Forum Discussion
date conversion not responding
I am trying to format a date column to MM/YYYY, however, none of my attempts to change the column are working.
Most probably you have texts which kooks kike dates, not the dates in terms of Excel (actually they are integer number formatted as dates).
If so, you may convert texts to dates selecting the column, Data->Text to Columns, on the third step of the wizard for the column select Date and MDY (or DMY, or else, depends on how they are presented in texts). Finish and apply desired date format to the column.