Date Format

Excel 688 views 2 replies

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

Replies (2)
I think u can solve this by going to CUSTOM section and change it or format accordingly
Originally posted by : D н ! я σ √
I think u can solve this by going to CUSTOM section and change it or format accordingly

 It not works !


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register