- 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!
- Works with Microsoft Excel® 2000, 2002, 2003, 2007 and 2010.
123 | -123 | (123) | |
1.23 | -1.23 | (1.23) | |
1,234.56 | -1,234.56 | (1,234.56) | |
$1.23 | $-1.23 | ($1.23) | -$1.23 |
$1,234.56 | $-1,234.56 | ($1,234.56) | -$1,234.56 |
$1.23E2 | -$1.23 | -$1,234.56 | |
123% | -123% | (123%) | (123)% |
1.23E2 | -1.23E2 | (1.23E2) | (1.23)E2 |
1/3 | -1/3 | (1/3) | (1)/3 |
1 1/3 | -1 1/3 | (1 1/3) | (1) 1/3 |
1,234 1/3 | -1,234 1/3 | (1,234 1/3) | |
August 3, 2004 | 2004-8-3 | 3-Aug-2004 |
The Additional Date Formats Recognized
2003.1.2 11:12:13:14PM 2003.1.2 11:12:13PM 2003.1.2 11:12PM 2003.1.2 11 2003.1.2 2003.01.02 2003.1 11:12:13:14 2003.1 11:12:13 2003.1 11:12 2003.1.2 11:12PM 2003.1 11 2003.2 11:: 2003.2 11::13 2003.1 :::: 2003.1 ::: 2003.1 :: 2003.1 : 2003.1 :12:13 2003.1.2 :12:13:14 2003.1.2 11::13:14 2003.1.2 11:12::14PM 2003.1.2 11:12:13:PM 2003.1.2 11PM 2003.1.2 11:12PM 2003.1.2 11:12:13:PM 2003.1.2 11:12:13:14mm 2003.1.2 11:12:13xxxx 2003.1.2 11:12xxxx 2003.1.2 11xxxx |
2003-1-2T11:12:13:14PM 2003-1-2T11:12:13PM 2003-1-2T11:12PM 2003-1-2T11 2003-1-2 2003-01-02 2003-1t11:12:13:14 2003-1t11:12:13 2003-1t11:12 2003-1-2T11:12PM 2003-1T11 2003-2T11:: 2003-2T11::13 2003-1T:::: 2003-1T::: 2003-1T:: 2003-1T: 2003-1T:12:13 2003-1-2T:12:13:14 2003-1-2T11::13:14 2003-1-2T11:12::14PM 2003-1-2T11:12:13:PM 2003-1-2T11PM 2003-1-2T11:12PM 2003-1-2T11:12:13:PM 2003-1-2T11:12:13:14mm 2003-1-2T11:12:13xxxx 2003-1-2T11:12xxxx 2003-1-2T11xxxx 2003-1 |
20030102 11:12:13:14PM 20030102 11:12:13PM 20030102 11:12PM 20030102 11 20030102 30102 200301 11:12:13:14 200301 11:12:13 200301 11:12 20030102 11:12PM 200301 11 200302 11:: 200302 11::13 200301 :::: 200301 ::: 200301 :: 200301 : 200301 :12:13 20030102 :12:13:14 20030102 11::13:14 20030102 11:12::14PM 20030102 11:12:13:PM 20030102 11PM 20030102 11:12PM 20030102 11:12:13:PM 20030102 11:12:13:14mm 20030102 11:12:13xxxx 20030102 11:12xxxx 20030102 11xxxx |
2003-1-2 11:12:13.14PM 2003-1-2 11:12:13PM 2003-1-2 11:12PM 2003-1-2 11 2003-1-2 2003-01-02 2003-1 11:12:13.14 2003-1 11:12:13 2003-1 11:12 2003-1-2 11:12PM 2003-1 11 2003-2 11:: 2003-2 11::13 2003-1 :::: 2003-1 ::. 2003-1 :: 2003-1 : 2003-1 :12:13 2003-1-2 :12:13.14 2003-1-2 11::13.14 2003-1-2 11:12:.14PM 2003-1-2 11:12:13.PM 2003-1-2 11PM 2003-1-2 11:12PM 2003-1-2 11:12:13:PM 2003-1-2 11:12:13.14mm 2003-1-2 11:12:13xxxx 2003-1-2 11:12xxxx 2003-1-2 11xxxx |