|
Excel Number
Manager Add-in - For Managing of all Numbers in Microsoft
Excel Spreadsheets
The Excel Number
Manager Add-in 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 List box where you can
select anyone of 172 currency codes to format you numbers as
USD25.00, AUD356.32 etc. All this and much more!
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.
The Excel
Number Manager Excel Add-in Consists of 3 Main Page Tabs:
- Format
- 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.
- Change
Value
- Round up
- Round down
- Round to any specified number of decimal places.
- Increase
- Decrease
- Multiply
- Divide
-
Convert/Remove
- Remove all text and leave only numbers.
- Remove all numbers and leave only text.
- Convert imported negatives to true negatives. E.g 100- to
-100
- Convert imported dates to true Excel dates.
|
