Hi
I've been on this for days now and cant get a solution!
I have downloaded a template to use for work to record staff absence, it's an American version obviously called Employee Attendance Tracker
I have tried every thing I can think of to get it to change to UK version dates as it currently is set at Month/Date
I've tried formatting the cells individually (by changing to English UK) I've tried changing the language and region on my PC (to UK) everything I could find online I've tried.
I tried formatting cells individually which will work sometimes then in the next cell when I type a number (ie 18 for the 18th of the month) it changes it to 182!
Someone please tell me a quick way of doing this before I give up completely and get sacked!
Bookmarks