joe spencer
New Member
- Joined
- Apr 15, 2002
- Messages
- 2
I use excel for calculating wages for a large group of people in a company.Each person has a card for tax deduction purposes and each week on the card has a date which was formatted dd/mm/yy. For no apparent reason all the dates in all the Excel workbooks have changed to mm/dd/yyyy. I recently took a Microsoft Excel test on line. Could this have caused the changes to happen? Is there an easy way to revert back to the original dd/mm/yy, without having to correct each individual sheet, as I have hundreds to undo?