Forum Discussion
Excel 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.
This usually has to do with the system date format (m/d/yyyy vs d/m/yyyy), but without knowing any details it's hard to be more specific.
- It completed the document partly in Mexico and partly in the US. I can’t change the dates displaying day month year to month day year. Any suggestions?
Can you distinguish between the rows completed in Mexico and those completed in the USA? If so, it might be possible to correct them using a formula or VBA. Otherwise, you're left with a messy situation...
- Yes I can tell.
