Date Format

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 !

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
16 October 2026
CA article trainee

Zerdi & Co. Chartered Accountants

Pune

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details