How change date format in excel

Closed
sudhansu - Nov 1, 2014 at 02:12 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 1, 2014 at 02:31 AM
Hello,

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

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Nov 1, 2014 at 02:31 AM
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?
0