Microsoft Excel can automatically detect dates, times, currencies, and more from text and convert them into a parsed format for use in formulas. However, Excel often gets conversions wrong, especially when it comes to dates, which Microsoft is now working to address.
Read This Article on How-To Geek ›
Source : Microsoft Is Finally Fixing Excel’s Data Conversion Problem
