banner_ad

Lets take an example, you have a long set of dates in cells like below. And you want to change the date format as a dd-mm-yyyy format. So that it can show the date format like 2-Apr-2014, which is easy to read. Normally what we do is, Select the entire range of cells Right click
Daily Limit Reached

You have reached your daily limit of 2 Free Articles

Subscribe to CCI PRO for unlimited access

Why Upgrade to CCI PRO?
  • No Ads
  • WhatsApp Broadcasts
  • Daily E-Newsletter
  • Unlimited Articles Access
BEST VALUE
2 YEAR PLAN
3,499
(Inclusive of GST)
1 YEAR PLAN
1,999
(Inclusive of GST)
Buy CCI PRO Now

Already a PRO member? Login here for an ad-free experience.


35798 Views 3 Likes Comment   Share Students   Report


About the Author

Trainer

/coaching/excel.asp


CCI Pro

Comments


Related Articles


Loading


Popular Articles





CCI Pro
Meet our CAclubindia PRO Members

CCI Articles

submit article


Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details
Company
ARTICLESHIP 14 May 2026
CA ARTICLE

PRAVEEN GARG & CO

Faridabad

CA Foundation

View Details
Company
14 May 2026
ICSI Trainees for 21 Months and Semi-Qualified CS

CMNITY HIRE

New Delhi

Others

View Details
Company
22 May 2026
Sr. Financial Analyst - Consolidation

Search Synergy

Mumbai

CA

View Details
Company
26 May 2026
Audit executive

vdsr & co LLP

Chennai

CA Inter

View Details
Company
18 May 2026
MIS Executive

Primarc Pecan Retail Limited

Mumbai

B.Com

View Details
Company
ARTICLESHIP 15 May 2026
Audit Assistant / Article Trainee / Intern

SSGS and Associates

Chennai

CA Inter

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details