By default, Excel accepts date input in MM/DD/YY format (US format) unless you change the control panel settings of your PC. Example 22.10.2007 or 22/10/2007 date may be considered invalid. Important Note:Technically, every valid date is a number to Excel. Lets see how Text to Columns can help
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.




About the Author

Trainer

/coaching/excel.asp


Related Articles


Loading


Popular Articles





CCI Pro

CCI Articles

submit article


Company
ARTICLESHIP 10 July 2026
Article Assistant

N S Gokhale & Co

Thane

CA Inter

View Details
Company
ARTICLESHIP 14 July 2026
Article Assistants

R Shyam and Associates

New Delhi

CA Final

View Details
Company
05 July 2026
Financial Controller

NovumLake Partners

Mumbai

CA

View Details
Company
ARTICLESHIP 23 July 2026
Article

Gianender & Associates

New Delhi

CA Inter

View Details
Company
13 July 2026
AVP / VP - PCG Advisory

Workforce Connect

Mumbai

MBA

View Details
Company
Featured 16 July 2026
Semi Qualified Company Secretary

Vakilsearch.com

Chennai

CS

View Details
Company
Featured 18 July 2026
CA Articleship

apricus india

Mumbai

CA Inter

View Details
Company
Featured 18 July 2026
Senior Manager- Finance & Accounts

apricus india

Ahmedabad

CA

View Details