built4thekill
New Member
- Joined
- Oct 26, 2020
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
Hi All. I'm having an issue which is driving me crazy!! I'm sure the solution is easy but I cant find it. Basically I have a cell in which I'm supposed to type in a date then a corresponding cell will give me a DoB. Now whenever I type in the date in UK format it keeps changing it to US! I've tried changing the format to Date - English UK and also Custom - dd/mm/yyyy but it still changes it to US each time. E.g. 03/04/1980 (3rd April) would auto change to 04/03/1980 (4th March). Any help would be really appreciated!!