Home > Products >
Addintools Assist for Excel
Addintools Assist for Excel® |
|
Unit Price:39
|
 |
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. |
|
Recognize and convert data type of cells |
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.
The Additional Text Format Recognized:
All formats: August 3; 2004 3-Aug-04; 08/03/2004 00:00:00;
2004.08.03; 123456.789; 12345678.90%; US$123,456.79; 1.23E+05; ......
The Additional Numeric Formats Recognized:
| 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 |
|
Locked & Unlocked Cell Lens |
| When you open a protected worksheet
which you constructed in the past, can you remember
which range is locked and which range is unlocked?
What will happen if you send customers a document
which includes some cells that have been locked
incorrectly? |
|
Design Protected Worksheets
Efficiently! |
The Locked & Unlocked Cell Lens
changes the background color of cells according to their lock/unlock
state: locked cells to gray,
and unlocked cells are shown in blue. Assist
also offers a Quick Lock button to lock the
selected range at once and a Quick Unlock
button to unlock immediately. Now you can
clearly see which cells are locked and which
cells are unlocked. Just cancel this Cell
Lens and the original background color will be restored.
|
| Cell Lens of Data Type |
| When you are using a summary formula or other math
formulas in Microsoft® Excel®, do you sometimes find that the
summary value is incorrect and some cells are not included
in the summary? If the format is incorrect, Excel
considers the data of these cells as text rather
than number. The text is always treated as zero when totaling,
so the value of the summary is incorrect. |
|
| Seek Invalid Data Type Quickly! |
Excel can recognize the data type of cells and
ranges, but users cannot. Addintools Assist offers
the function Data Type Cell Lens. It renders and changes the background
color of cells according to their data type: Text changed to green,
Number to blue, Date and Time to yellow, empty cells changed to "No Filled Color".
Cells that include text and are therefore totaled incorrectly will be
visible at
once. You can use the Data Type Conversion to convert the data of
those cells to number type. You will then get the correct value
in your
summary. Just cancel the Data Type Cell Lens,
and the background color
of all cells will be restored to their original state. |
|
*Microsoft and the Office logo are
trademarks or registered trademarks of Microsoft Corporation in the
United States and/or other countries.
|
|
