What it does
Uses picker prompt to apply number formatting using defined number format type (currency, percentage, custom, etc.), which also work with the Toggle Number Format macro.

Up to five number formats can be customized using the Number Format Picker macro or the Assign Macro Defaults macro.

When to use it
Any time you want to change the number format for one or more cells using one of your five favorite/pre-selected number formats, this is is an easy way to quickly apply them or reset your favorites.

Why to use it
It’s easier and quicker than using the mouse, especially when you leverage keyboard shortcuts – between the default options and customizable options, it’s like twelve shortcuts in one.

Default shortcut
None

Other Details

• Category: Formatting / Number Formats
• Difficult: 3/5
• Usage/frequency: 3/5
• Automation factor: 4/5 (estimated 5 seconds saved each time used)
• Type: Shortcut
• Date added: 11/11/2017
• Tags: Cell number format, picker

Related Macros
Toggle Cell Highlight
Number Format Shortcut
Assign Macro Defaults

Other Articles
None

None

Prerequisites
Select the cell or cells you wish to change the number format for.  The cells do not have to be contiguous.

Instructions
With your intended cells selected, run the Number Format Picker macro.  It will present several common formats as well as your five favorite number formats codes with the example of how those number formats apply to the value in the top-left selected cell.  Just enter the corresponding option code letter/number and click enter to run.  That’s it!

Like most of the picker macros, you can set the default option to apply so you don’t even have to enter the letter/number – just the Enter key.  Just enter your preferred default letter/number, then click the default checkbox, and that letter/number becomes the new default.  To change the number format options, follow the instructions below.

To change the five default number formats, there are two options:

1. Use the Number Format Picker.
   1. Set a cell number format to the one you want to use as a favorite/toggle.  Run the Number Format Picker macro.  The number code will be displayed with the instructions.
   2. In the text box, enter X, then a space, then DEFAULT# where # is the corresponding picker # (1 through 5).  Example: If the cell number format has a code of 0.0%;(0.0)%;0.0%, entering “X DEFAULT1” would would set the toggle and picker value to “1: (Custom 1) 0.0%;(0.0)%;0.0% [12.0%]” and you would just enter 1 in the picker to set that number format, or use the Toggle Number Format macro for that as the first toggle value.
2. Use the Assign Macro Defaults macro.
   1. Run the Assign Macro Defaults macro.  It will take a few seconds to export all default values to a new sheet in the active workbook.
   2. Search for “Toggle Number Format” in the newly created sheet.  Follow the instructions in the cell comments to set one or more default number formats.
   3. Run the Assign Macro Defaults macro again to process the changes.