How to enter date in particular format

[usmanhere]

Hi

I want to enter date in excel in this format dd.MM.yyyy rather than MM/dd/yyyy

i.e. when we enter date in excel we use slashes as narrated above and months are entered before the days.

how can we enter dates in the format as "dd.MM.yyyy"

 

[Faseeh]

Hi usmanhere,


Select the cell, right click, select cell formatting, go to custom, in space provided under 'Type' write 'dd.mm.yy' .... Apply this formatting to rest of the cells


Regards,

Faseeh

 

[oldchippy]

Hi usmanhere,


You may also find this a useful reference


http://excelribbon.tips.net/T008319_Understanding_Date_and_Time_Formatting_Codes.html

 

[usmanhere]

You didnt get me. Wat u have just told me, is for the date to be displayed as dd.MM.yyyy and date has to be entered in MM/dd/yyyy. But i want to make entry of the Date this way, i.e. dd.MM.yyyy

 

[Luke M]

You need to change the Windows regional settings to do that.

http://support.microsoft.com/kb/307938

 

[SirJB7]

Hi, usmanhere!


Tried changing your regional configuration from Control Panel to a country that has dot as date separator?


Regards!

 

[usmanhere]

Thanx that helped me.

Great