Forum Discussion
Problem Formatting and Sorting Dates
First time posting, so I hope I'm doing this right. I work in healthcare and use Excel 2013 on my work computer. I frequently have to download spreadsheets of data that come with dates in "Genera...
mnaber Use Text-to-columns and in step 3, make sure you select Date and the format that the original date comes in. For instance, DMY means that you have dates like 10/08/2022, being 10 August 2022.