Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Manage Numbers In Excel

 

EXCEL VIDEO TUTORIALS / EXCEL DASHBOARD REPORTS

Excel Number Formats, Convert text to numbers & more

BUY Excel Number Manager

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, negatives in brackets, hide negatives, hide positives, hide zeros, hide text, hide numbers, or hide 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!

Overview of the Excel Number Manager Add-in

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.

The Excel Number Manager Excel Add-in Consists of 3 Main Page Tabs

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.

Number Manager Excel 97 or above | Secure Payment Options | 30 Day Money Back Guarantee & Huge Discounts for Unlimited Licenses | Buy on its own or buy as part of the Excel Add-ins Collection for not much more and get our Complete Excel Course for FREE. You will be able to download your Excel Add-in immediately after ordering.

Order Type:

Single user license =2 users 2 computers| Unlimited user license = unlimited users unlimited computers | Resellers user license = Do anything you like with the add-in, including rebranding and reselling. That is, NO RESTRICTIONS AT ALL. Please email the support address and include your order number so we can send you the code password. Resellers user license ONLY

Many More Excel Add-ins & Templates & Software


Instant Download and Money Back Guarantee on Most Software

EXCEL VIDEO TUTORIALS / EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS