Converting invalid date formats to valid ones in excel

CA Rishabh Pugalia (ExcelNext) , Last updated: 26 April 2021  
  Share

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

You have reached daily limit of 2 Free Articles. To view this or other Articles please subscribe to CCI PRO :

GST Plus

Stay updated! Stay ads free

Browse CAclubindia ads free.
Latest updates on WA.
Daily E-Newsletter and much more.

CCI PRO annual subscription :

Original Price : INR 2999/-

Offer Price : INR 1999/-

Duration : 1 year
(Prices Inclusive of GST)


Know More

Note: If you are a PRO member already, please click here to login (for ad free experience)

CCI Pro

Published by

CA Rishabh Pugalia (ExcelNext)
(Trainer)
Category Info Technology   Report

Other Articles  
Comment   Share
  23398 Views
Comments

Related Articles


Loading


Popular Articles




CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Trending Online Classes

view all classess

Follow us
OR add as source on Google news

CCI Articles

You can also submit your article by sending to article@caclubindia.com

submit article

Browse by Category