|
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.
|