Forum Discussion
malmo_040
Jan 23, 2019Copper Contributor
Change format from text to date in multiply cells
Hello. I would need to change the format in multiply cells at the same time, but it doensn't work. In my job, I get a excel list where dates are in the text format. I want to change them to the "...
SergeiBaklan
Jan 24, 2019Diamond Contributor
Select you column, on ribbon Data->Text to Columns, on third step of the wizard select Column data format as Date with YMD option.