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