×

Current Version: Version 1.0 (with Icon Library 1.0)

Compatibility: PC Only | Excel 2007 or later (including Office 365 Desktop) | Works on 32-bit or 64-bit

License: 1 user per license (up to 3 of your personal devices per single license)

help-page: Number Formats Help Page

Never Type A Custom Number Format Rule Again!

If you’ve been an Excel user for some time, chances are you’ve found custom number formats outside of the rules available to you on the Home tab. That’s because we all use Excel for different reasons and rely on various formats to make our data meaningful and easy to consume. What can be painful though, is adding these specific number formats to all our spreadsheets. After spending years manually typing out my preferred number format rules, I finally had enough! I set out to begin utilizing VBA macros to quickly apply my frequently used formats to selected cells.

Utilizing VBA code to apply various number formats was the foundation of what eventually became the Number Formats Excel Add-in. This Add-in allows you to store all your favorite custom number formats in your Excel Ribbon so you can quickly apply them to your spreadsheets anytime you want!

Feature Summary:

  • Store up to 135 Custom Number Format Rules

  • Full Button Customization (label, icon, hover-tip, location)

  • Add Favorites to your Home Tab

  • Apply Quick Math to your selected data

  • Includes Icon Library for the Excel Ribbon

  • Cycle through 3 Format Rules per button

  • Excel’s Decimal, Font/Fill Color, & Border buttons included

  • Apply Text Alignment with your Number Formats Rule

  • No recurring subscription (isn’t that refreshing?)

  • Free Updates

  • 30-day money-back guarantee

  • Load to 3 personal devices per licensed user

Your format rules with 1-click

The Number Formats Excel Add-in allows you to easily create up to 45 Ribbon buttons for all of your favorite Custom Number Formats.

  • Add-in enclosed in the brand new Numbers Tab

  • Up to 3 Custom Number Formats per button

  • Pick your own button icons or use your own

  • Decide what your buttons labels say on the Ribbon

  • Choose the order of all your Ribbon buttons

Number formatting rules in the Excel ribbon

Watch How Easy It Is To Create A New Button! (4 mins)

Store your favorite rules

The heart and soul of this add-in is the ability to easily customize and store all your favorite Number Format rules. This begins with an easy-to-use Rules Manager built right into the add-in.

  • Create up to 45 buttons (that’s over 130 rules!)

  • Delete Buttons

  • Copy Buttons

  • Edit Buttons

  • Re-position the order of your buttons

Number formats manager
Complete customization

With the Number Formats Excel Add-in, you have complete control over what your buttons do. Look at all the customization you can do:

  • Choose your button label text

  • Add up to 3 number format rules to cycle through

  • Pull number format rules from spreadsheet cells

  • Add a preferred text alignment along with your rule

  • Customize the tooltip text shown while hovering over your buttons on the Ribbon

  • Load a custom icon file (.png only) to display as your Ribbon button (don’t worry, a whole icon library is included with your purchase)

All the options and settings for Number Formats add-in
3-rules per button

Each rule within the Number Formats Add-in allows you to store and cycle through up to 3 Custom Number Format Rules. There are built-in checks to ensure your rules are valid and you can even pull already created rules from a selected cell in your spreadsheet!

This feature is extremely handy when you want to quickly cycle through different decimal places or date formats.

Example of 3 custom number format rules

Look at this feature in Action!

Notice how when a single button gets clicked, different variations of the format rule get applied.

You can cycle through up to three format rules of your choosing before ending back up at the “General” number format.

This is perfect if you want to quickly add decimal places or modify what your zero value looks like.

Number Formatting Excel add-in feature

This is perfect if you want to quickly add decimal places or modify what your zero value looks like.

 
Custom Icon Library

The Number Formats Excel Add-in allows YOU to pick the icons you want representing your number formats. You can use any 16x16 pixel icon saved as a .png file type, however, I have a full library of icons you can download and use to get started. There are a plethora of currency icons available including the Euro, Yen, Rupee, and even Bitcoin. I will continue to gather icon ideas and grow the library over time. All icons will be free for users to download and use however they wish.

Icons Included:

Icons and symbols
Perform quick math to your data

While working with data you don’t only need to reformat it, there are also times when you need to manipulate it. I thought it was a no-brainer to integrate another add-in of mine (the SideKick Excel Add-in) to allow you to perform simple math on your spreadsheet data. The re-branded Quick Math button will allow you to select data and do the following mathematical manipulations:

  • Add, Subtract, Divide by, Multiply by a specific number

  • Hardcode Formulas

  • Switch signs (positive/negative)

  • Zero out data

  • Keep the userform pinned for continuous use while you work

For more detail on what Quick Math can do, visit the SideKick Add-in Page.

Quick math settings panel
Save favorites to the home tab

Let’s face it, you are going to be using these buttons A LOT! You’ll soon get pretty tired of navigating to the Numbers tab to apply your number formats. That’s why the Number Formats Excel Add-in has an option for you to save your favorite formatting buttons to Excel’s Home tab. Just tick the “Show On Home Tab” option in your rule setup and your button will show on both the Home Tab and the Numbers Tab.

Home tab favorites
Apply to tables and pivot tables

No need to select an entire column in your Excel Tables or Pivot Tables. You can simply select a single cell and your number format will get applied to the entire column’s data set within the object!

Watch this feature in action:

How to apply number formats to tables and pivot tables
The spreadsheet guru guarantee

Free Future Updates

As with all purchased products sold by TheSpreadsheetGuru, you don't have to worry about purchasing too early! After you purchase this add-in, you will be placed on an exclusive email list where you will directly receive any update made to this product.

No Subscription

This product does not use the recurring subscription model. That means you pay ONE-TIME and you get to keep your product forever! Isn’t that refreshing?

30-Day Money Back Guarantee

I'm so confident you will love this Excel spreadsheet, I'm willing to give you 30 days from your purchase date to decide if this is the tool for you. If you come to the conclusion that this Excel add-in was not what you were expecting, just shoot me an email and I'll refund you your money back.

So what's there to lose?Now is your opportunity to pick up this revolutionary Excel add-in that will allow you to have all your favorite custom number formats readily available for you to use with the click of a button.

Click the Buy Now button below to quickly get your hands on this amazingly powerful Excel add-in!


What Are You Waiting For?!

You now have the ability to store all your favorite custom number formats inside the Excel Ribbon. Gone are the days of you typing and re-typing your number formats in every spreadsheet you create. So what are you waiting for? Pick up your copy of the Number Format Excel Add-in today!

  • Store up to 135 Custom Number Format Rules
  • Full Button Customization (label, icon, hover-tip, location)
  • Add Favorites to your Home Tab
  • Apply Quick Math to your selected data
  • Includes Icon Library for the Excel Ribbon
  • Cycle through 3 Format Rules per button
  • Excel’s Decimal, Font/Fill Color, & Border buttons included
  • Apply Text Alignment with your Number Formats Rule
  • No recurring subscription (isn’t that refreshing?)
  • Free Updates
  • 30-day money-back guarantee
  • Load to 3 personal devices per licensed user
Download free 14-day trial
Buy now for $47

Review The Number Formats Add-in!

I want to hear from you! Share your story of how the Number Formats Excel Add-in has helped you save time and become more efficient with Excel. I love hearing feedback and getting ideas for future updates. I look forward to reading your thoughts! 🙂