Fill in the gaps in Excel workbooks

Number Manager in detail

The Number Manager fills in the gaps in Excel when working with numbers. It allows you to add 15 different number formats that are not part of Excel's built in number formats. Retain leading zeros, show dollars and cents, align all decimals, have negatives in brackets, hide negatives, positives, zeros, text, numbers, or all. There is even a Listbox where you can select anyone of 172 currency codes to format you numbers as USD25.00, AUD356.32 etc.

Ever had those stubborn numbers that Excel only sees as text? With the Number Manager all you do is click the Force To Numbers and the problem goes away.

The Round option on the Change Value tab allows you to instantly round up, round down or round to any specified number of decimal places. The Alter values can be used to increase, decrease, multiply or divide your numbers by any value or percentage.

The Convert/Remove tab is just the thing for those stubborn imported (or not) numbers and text. You can remove all text from a mix of text and numbers, remove all numbers from a mix text and numbers. A common problem with numbers being imported is some programs (SAP etc) bring in negatives as 100- instead of -100. Excel will see these as text and not negative values. With the Number Manager all you do is click a button and they are instantly put the right way. Another common issue is dates ending up as 010503 (01/05/03), 1503 (1/5/03) etc. Excel think these are numbers and not dates, meaning you cannot work with them. With the Number Manager you click a button and they are changed to become real dates that Excel does recognize.

See also in "Excel - Data management - merge, convert, delete"

• Address Assistant - Split addresses from one cell into multiple cells.
• Consolidation Assistant - Consolidate data from Excel workbooks or worksheets.
• CSV File Creator - Create a CSV file from Excel workbooks / worksheets.
• Data Assistant for Excel - Make table form data applicable for Excel pivot tables.
• Data Cleaner for Excel - Remove spaces, Change text case, Replace / modify text, etc.
• Data Extraction Assistant for Excel - Extract data from one worksheet to many spreadsheets.
• Data Loader for Excel - Easy loading, processing, and transferring data .
• Filter Assistant - Filter multiple Excel spreadsheet columns at a time.
• Formula Manager - Manage all formulas in Excel worksheets easily.
• Formula Ref Changer and Sheet Index Creator - Change Excel formula reference types.
• List Assistant - Easy way to re-arrange rows in your Excel worksheet.
• Name Splitter - Split names into several Excel cells.
• Report To Data Assistant - Convert text reports into Excel worksheet databases.
• Spreadsheet Assistant - Over 200 useful features for MS Excel.
• Text File Importer - Import text files with over a million lines into Excel.
• Text Manager - Change case in Excel, Join text to one cell, Remove spaces, etc..