How change date format in excel [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

how to change and edit in date format dd/mm/yyyy in excel

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
note that date is entered according to your computer configuration

see control panel - region and language-short date

once you enter date according to this you can format as you like. it will look like that but entry will be as you entered.

you got it?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!