Addintools Assist for MS Excel is a nice extension for Excel and will help you recognize and convert data type of cells.

Here are some key features of "Addintools Assist for MS Excel":

· 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$123,456.79, 1.23E+05 ...
· Safety Merge Cells and Smart Unmerge.
· View invalid data type in cells by colors.
· View invalid lock/unlock state in sheets and books by colors.


Other features for "Addintools Assist for MS Excel":

· Virtual Rulers
· Cell Lens of Data Type
· Cell Lens of Locked/Unlocked
· Anchor Toolbars
· Disable/Enable Customizing Toolbars
· Convert to Dates&Times
· Convert to Numbers
· Convert to Texts
· Safety Merge and Smart Unmerge


Requirements:

· Office/Excel 2000/2002(XP)/2003


Limitations:

· 30 days trial