Date change in excel sheet [Closed]

Report
-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
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