Excel Number Management
Rate this solution:(3/5 from 1 vote)
The Number Management Add-in for Excel fills in the gaps in Excel when working with numbers. It allows the addition of 15 different number formats that are not part of Excel's built in number formats. There is also a list box where any one of 172 currency codes can be selected to format numbers (such as USD65.00 or GBP162.09 etc). |
The Force to Numbers feature allows the automatic conversion of numbers that Excel only recognizes as text to true numeric values.
The Round option on the Change Value tab allows 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 numbers by any value or percentage.
The Convert/Remove tab is designed for lists imported (or not) of numbers and text. All text can be removed from a mix of text and numbers, or all numbers removed from a mix text and numbers.
A common problem with numbers being imported is some programs (SAP for example) outputs negatives as 100- instead of -100. Excel will see these as text and not negative values. With the Number Management Add-in for Excel these can be corrected instantly with one click. Another common issue is dates being recognized as numbers by Excel such as 020607 (02/06/07) or 2607 (2/6/07). With the Number Management Add-in for Excel these can be converted as real dates that Excel does recognize. The Number Management Add-in for Excel consists of 3 main page tabs:
The Number Management Add-in for Excel is also available in the following discounted bundled offers:
Price: USD 29.95
(Updated on 2012-09-21)
Related Excel Solutions for Number ManagementFormula ManagementTime Saving Productivity Add-insTime Saving XML ExportConverting and Integrating Table ManagementData Management Text ManipulationTime Saving Name ManagementTime Saving Duplication ManagementTime Saving Convert ValuesData Management
|Share your thoughts and opinion with other users: Create Review|
Browse Main Excel Solution CategoriesBusiness Finance Financial Markets Operations Management Excel Productivity