If you have ever had to import data into Excel you will likely have
encountered problems such as, numbers being seen as text, negatives sign on the
right of numbers, dates not being recognized and many more problems.
Remove all text and leave only numbers. Imagine you have many cells that
house both text and numbers. You need to extract out only the numbers and not
the text. With the Excel Number Manager Add-in you can now do this in 3 clicks.
Remove all numbers and leave only text. Imagine you have many cells that
house both text and numbers. You need to extract out only the text and not the
numbers. With the Excel Number Manager Add-in you can now do this in 3 clicks.
Convert imported negatives to true negatives. Unfortunately it is quite
common for some programs (SAP for one) to dump negatives into Excel with the
negative sign on the right, not left. This then means Excel sees the numbers
as text and cannot be used in calculations. Now, with the click of a button,
all these will be converted to the correct negative format. Eg 100- will become
-100
Convert imported dates to true Excel dates. Another common problem with
imported data is that many dates are not seen as dates by Excel. This again
means Excel cannot use these in any calculations. For example, dates that are
imported as ddmmyy, mmddyy etc are not seen by Excel as dates. Now, with the
click of a button, they will be converted to true Excel dates, such as dd/mm/yy,
mm/dd/yy etc. Once they have been converted you can apply any Excel date format
you like.
Force to numbers. Importing, copying etc numbers into an Excel Worksheet
can often leave you with excel seeing the numbers as text and not true numbers.
This can be extremely frustrating as all appears ok. However, when these 'so-called'
numbers (which are really text) are used in calculations, you end up with #VALUE!
error or the formula being displayed in the cell as apposed to a result. One
click of the Force to numbers button and the problem goes away.
30 Day Money Back Guarantee On All Excel Add-ins! Big Discount for Unlimited
LicenseYou will be able to download your Excel Add-in immediately after
ordering.
The Excel Number Manager Excel Add-in Consists
of 3 Main Page Tabs
Contact Us
After Purchase For Passwords for Resellers License
Special
! Free Choice of
Complete Excel
Training Course OR Excel Add-ins Collection
on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets
you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com
31 days after purchase date.
Excel Online
Excel 97 or above. 30 Day Money Back
Guarantee.
Payment Problems/Options
SAVE by buying as part of a
Add-ins collection