Forum Discussion
Conversion from European Date Format
I'm using Excel 365. I just copied a column of dates from a web page and pasted them into a column in Excel. The dates on the web page were in the European date format (i.e., dd/mm/yyyy). When pas...
Most probably you pasted dates as texts, if so only format won't help. Select column with such dates, Data->Text to Columns and on third step of the wizard select Date and DMY. Finish. If my guess is correct you shall see the dates now in your default format. You may change it on another one selecting the column again, Ctrl+1, Number, Custom format, mm/dd/yyyy