Date change in excel sheet

Closed
chandresh - Dec 28, 2014 at 10:51 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 29, 2014 at 04:19 AM
Hello,

in excel sheet date come to 29/12/2014 now i wants date on 29/12/14.
so help me how to change date format or use formula to change date from 8 digit to 6 digit..

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 29, 2014 at 04:19 AM
how excel date is to be entered in your computer
m/d/yyyy or d/m/yyyy
see controlpanel-region and language=short date
according to this enter date then only it will be date

then fomar as you like d/mm/yy will be there in the format choices
0