Typing in Date format in Excel

[LT_SIN]

Hi i need help and i cant seem to find a solution anywhere on google.

I usually type in 25/02 (day/month) on my keyboard and excel usually format it automatically to 25-Feb-18

But when i type in 04/02 it automatically sets it to 02-Apr-18 which is suppose to be 04-Feb-18

Is there any way i can change this? any help appreciated. thanks

[sandy666]

maybe change your local settings to : dd/mm/yyyy

[ExcelHelps]

That is in Format. Select your Row/Column that you want changed then go to Format. Select Style and another box should pop up. Go down to Date and select the correct format you want. Hope this helps!