Convert data format between Date Numeric Text. Recognize more than ten formats of date: 12/31/2006 2006-12-31 2006.12.31... Recognize more than 36 formats and convert to numeric: '123.45 (1.23)E2 (1) 1/3 ... Recognize all formats and convert to text: August 3 2004 08/03/2004 00:00:00 12345678.90% US$123456.79 1.23E+05 ... Safety Merge Cells and Smart Unmerge. View invalid data type in cells by colors seek Invalid Data Type Quickly! View invalid lock/unlock state in sheets and books by colors design Protected Worksheets Efficiently!