Forum Discussion
Solved
Converting date formatted as text to date
I have exported a file from a website which downloads into a csv file. The dates are shown as mm/dd/yyyy and is left aligned which confirms that it is text and not in date format. I want to apply a...
Select entire column B;
On the Data ribbon, choose Text to columns;
Next;
Next;
Now in Step 3 of 3, select the Date button and choose MDY from the list;
Finish.
Now the text dates are numbers and can be formatted however you like. See attached.
By the way, your sheet was set to "Show formulas" on the Formula ribbon. Switched it off to get see the proper results. Copied the birthday texts to the side to check that the US style dates transformed to Canadian style correctly.
I tried with your instructions, get a message "Can not do it with merged cell." Any suggestions?
That's to unmerge cells and try to use them never ever, they are only source of problems. Try Center Across Selection where possible.