banner_ad

Date Format

Excel for Finance 813 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  

Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details
Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
24 May 2026
Accounts & Tax Executive

PARAS KHURANA AND CO

New Delhi

B.Com

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details