Number Manager

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.

 Download now     Click to buy from RegNow

User Opinions: 0 votes

Submit your opinions

1. Complete Excel Course (Business & Finance > Spreadsheets)
2. Excel and Excel VBA Tips and Tricks (Business & Finance > Spreadsheets)
3. Excel Download Package (Business & Finance > Spreadsheets)
4. Excel Duplication Manager Add-in (Business & Finance > Spreadsheets)
5. Excel Level 1, 2 and 3 Training (Business & Finance > Spreadsheets)
6. Excel Level 1 Lessons (Business & Finance > Spreadsheets)
7. Excel Level 2 Lessons (Business & Finance > Spreadsheets)
8. Excel Level 3 and Excel VBA Courses (Business & Finance > Spreadsheets)
9. Excel Level 3 & Excel VBA & Excel UserForm Courses (Business & Finance > Spreadsheets)
10. Excel Level 3 Lessons (Business & Finance > Spreadsheets)
11. Excel Levels 1 and 2 Training (Business & Finance > Spreadsheets)
12. Excel OzGid Plus With Duplication Manager (Business & Finance > Spreadsheets)
13. Excel VBA Level 1 and Excel UserForms (Business & Finance > Spreadsheets)
14. Excel VBA Level 1 Lessons (Business & Finance > Spreadsheets)
15. Excel VBA UserForm Lessons (Business & Finance > Spreadsheets)
16. Formula and Text Manager for Excel (Business & Finance > Spreadsheets)
17. Formula Manager (Business & Finance > Spreadsheets)
18. Formula Ref Changer and Sheet Index Creator (Business & Finance > Spreadsheets)
19. Number Manager (Business & Finance > Spreadsheets)
20. Number,Text & Formula Manager (Business & Finance > Spreadsheets)
21. OzGrid excel Addins Collection (Business & Finance > Spreadsheets)
22. OzGrid Excel Plus Add-in (Business & Finance > Spreadsheets)
23. Text Manager (Business & Finance > Spreadsheets)
24. Time Sheet Advanced (Business & Finance > Spreadsheets)
25. TimeAndWageBook (Business & Finance > Spreadsheets)