Forum Discussion
Solved
Date format
I would like to know if someone can assist me with the date formatting in excel. I am in South Africa and the date system we use is day, month, year, however when I type, 1/2/23 it comes and January ...
RobynBird23 Check you regional system (i.e. Windows) settings and make sure that you choose the locale that suits your requirements.
On my W11 system the date format for the South African locale is yyyy/mm/dd. However, the UK local does use dd/mm/yyyy.
So, pick the UK one if it's the same on your system. Now, Excel should automatically use that date format. No need to fiddle with custom formats, every time you enter a date.
Thank you so much for the above message. however, when I put it on date format dd/mmm/yy, and I type 1/5 and press enter , it displays as 5/Jan/2023/
it worked on my old laptop, now that I changed it I cant seem to correct it.
it worked on my old laptop, now that I changed it I cant seem to correct it.
You need to change your Laptop date format then as suggested by RobynBird23.
Pls Follow
Setting >> time & language >> Region >> Change data formats >> Change "short date & Long date"
(external links removed by moderator)