|
Main
> Business
& Finance >
Spread Sheets
> Number Manager |
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.
|
Buy
Now |
Key
features of Number Manager:
-
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.
And much more!
-
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.
|
|
Product
Information
|
-
Version: -
-
Price:
$29.95
-
Size:
6
MB
-
License:
Shareware
-
Developer:
Dave Hawley
-
OS:
Windows
-
Rating:
|
|
|
|