After setting date format from contral panel, in excel cell date shows as dd/mm/yy, but in formula bar it shows dd/mm/yyyy.
Can anybody please help me to change date format as dd/mm/yy in cell as well as formula bar .
Thanks in advance
After setting date format from contral panel, in excel cell date shows as dd/mm/yy, but in formula bar it shows dd/mm/yyyy.
Can anybody please help me to change date format as dd/mm/yy in cell as well as formula bar .
Thanks in advance