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 21 September 2026
Consultant - Reporting

Finrep Advisors LLP

Mumbai

CA

View Details
Company
19 September 2026
Finance Manager

Mugdha Art Studio

Hyderabad

CA

View Details
Company
ARTICLESHIP 15 September 2026
Freelance Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 18 September 2026
Industrial Trainee

Twenty Point Nine Five Ventures Private Limited

Noida

CA Inter

View Details
Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
08 September 2026
Semi-Qualified Assitant

Subrahmanyam & Sivudu CA Firm

Hyderabad

CA Inter

View Details
Company
Featured ARTICLESHIP 06 October 2026
Semi Qualified

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
ARTICLESHIP 21 September 2026
CA Article Assistant

KK & Company Chartered Accountant

Pune

CA Inter

View Details