MexJane15Copper ContributorAug 11, 2022Excel dates are transposing day and month I have dates in one of my Excel columns that transposing the day and month on some lines and I can not fix it.
Harun24HRBronze ContributorAug 12, 2022MexJane15 Suppose you dates in Column A then use below formula to Column B.=TEXT(A1,"MMM YYYY")