| |
Supports Microsoft Office/Excel 2007 now!
Convert data between Date, Numeric, and Text formats. Fast, smart, and safe to work with. Recognize more than ten date formats including: 12/31/2006, 2006-12-31, 2006.12.31... Recognize more than 36 numeric formats with the ability to convert text to numbers including: '123.45, (1.23)E2, (1) 1/3 ... Recognize all formats and convert them to text: August 3, 2004, 08/03/2004 00:00:00, 12345678.90%, US$123,456.79, 1.23E+05 ... Safely Merge Cells with a Smart Unmerge. View invalid data types in cells using color coding, seek Invalid Data Types Quickly! View invalid lock/unlock state in sheets and books by colors, design Protected Worksheets Efficiently!
If you are working in the USA and a foreign customer sends you a document, there are a number of cells that contain date&time as 2004-12-31, Excel (English edition) might not recognize it and will treat it as text. You will have to re-enter every date into Excel again. Addintools Assist could recognize these cells as dates and will convert them to the local date format of your computer. |
|