Forum Discussion
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 "...
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.
Hello.
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.
//Tim
