Date Format

Deepak Tapse (Accounts Manager - Taxation)   (1771 Points)

01 February 2010  

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