Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

ADD-IN TOOLS ASSISTANT

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Convert Rows In Excel to Charts, Diagrams, AutoShapes, Reports, Tables......

ADD-IN TOOLS ASSISTANT

  • Convert data format between Date, Numeric and Text.

  • Recognize more than ten formats of a date: 12/31/2007, 2007-12-31, 2007.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, 2007, 08/03/2007 00:00:00, 12345678.90%, US$123,456.79, 1.23E+05 ...

  • Safely merge cells and Smart unmerge.  View invalid data types in cells by color, seek Invalid Data Type Quickly! View invalid lock/unlock state in sheets and books by colors, design Protected Worksheets Efficiently!

Some Features

Immediately become a Excel expert and an Excel programmer!

You don't need any special skills or technology.

You just need to design a marketing analysis chart and have 1000 rows exist in a worksheet, Addintools Create will generate 1000 marketing analysis charts for you, one for each row.

Convert rows of Microsoft Excel data to Charts, Diagrams, AutoShapes, Drawings, WordArts, Reports, Tables, Cards, Labels, Forms and Sheets in just minutes.

Fast, smart, and safe to working for you.

 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.

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

Add-in TOOLS Assistant  $18.95 Download Demo | Developers Site
Secure Payment Options 30 Day Money Back Guarantee!


Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft