Change format from text to date in multiply cells

New Contributor



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 "YEAR-DD-MM hh-mm" format. I mark the entire column and change the format and press ok, but nothing happens. I need to dubbel click in every cell, and then press enter, to make the cells to transform them into the new format.


At the picture you can se the first column changed in the new format, when the numbers are to right side. The following columns have got the time and date format, but havent changed. They're still in the text format, put to the left of the cells.


excel hjälp.jpg


Does anyone know how I can get all the cells in the column to the new format, without dubbel clicking and enter clicking in every single cell?



3 Replies

Hello @malmo_040 ! Try it with selecting the whole column, then press F9 to update your column settings. Additionally go to HOME Tab - Options - in left navigation you will see the common settings of your workbook. Is it set manually (F9) or automatically?

Otherwise there must a converting formula to get this done, i believe.. Greets, Eva.



No, that doensn't work. I still have to get in to every single cell in the list and press enter. If i try to change multiple cells when I've pressed the enter key in some of them, and not in some of them, just the once I've pressed the enter key in changes to the new format.



Select you column, on ribbon Data->Text to Columns, on third step of the wizard select Column data format as Date with YMD option.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies