Forum Discussion
Excel Won't Format my Date
I have copied data from Excel running in compatibility mode and pasted it into the most current version of Excel where I need to the data to be. I need the data in this format: 01/01/2022 12:00:00 AM...
It sounds like those dates might be stored as text strings. Pick any cell with a 'date' and open format cells. Switch the category to General. If General shows the date like this and not a 5 digital number, you have text.
