![](\"https:\/\/i0.wp.com\/excelevate.co\/wp\/wp-content\/uploads\/2020\/10\/read_icon_green_transparent.png?w=30&ssl=1\"){kind=spacer}
XLEV8 EXCEL PRODUCT MANUAL<\/span><\/h1>\n\u00a0<\/p>\n
SEARCH NUMBER FORMATS \/ BULK EDIT NUMBER FORMATS<\/h2>\n
[\/et_pb_text][et_pb_toggle title=\u201dDetails\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n
What it does<\/strong><\/span> When to use it<\/strong><\/span> Why to use it<\/strong><\/span> Default shortcut<\/strong><\/span> Other Details<\/strong><\/span><\/p>\n [\/et_pb_toggle][et_pb_toggle title=\u201dRelated Macros and Articles\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n Related Macros<\/strong> Other Articles<\/strong> [\/et_pb_toggle][et_pb_toggle title=\u201dExample Files\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n None<\/p>\n [\/et_pb_toggle][et_pb_toggle title=\u201dInstructions\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n Prerequisites<\/strong> Instructions \u2013 Search Number Formats To add the custom number format used in the active cell to your library, click the Save Number Format button.\u00a0 You can remove a record or all records using the buttons on the right side of the search box.\u00a0 You can also launch the bulk edit form using the bottom button on the right.<\/p>\n Instructions \u2013 Bulk Edit Number Formats [\/et_pb_toggle][et_pb_toggle title=\u201dScreenshots\u201d _builder_version=\u201d4.27.4\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n Screenshot of the Search Number Formats macro.<\/p><\/div>\n<\/div>\n Screenshot of the Bulk Edit Number Formats macro.<\/p><\/div>\n<\/div>\n [\/et_pb_toggle][et_pb_toggle title=\u201dVideo\u201d _builder_version=\u201d4.21.0\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n TBD\u2026<\/p>\n [\/et_pb_toggle][et_pb_comments _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/body><\/span>","protected":false},"excerpt":{"rendered":" XLEV8 Add-in how to: Search Number Formats – Allows you to search for your favorite saved custom number formats and easily apply them to selected cells.<\/p>\n","protected":false},"author":1,"featured_media":33632,"parent":299,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-33631","page","type-page","status-publish","has-post-thumbnail","hentry"],"aioseo_notices":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/33631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/comments?post=33631"}],"version-history":[{"count":4,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/33631\/revisions"}],"predecessor-version":[{"id":33655,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/33631\/revisions\/33655"}],"up":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/299"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/media\/33632"}],"wp:attachment":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/media?parent=33631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Uses an auto-complete search box to find any custom number formats you\u2019ve saved to your library.\u00a0 It displays the date last updated, the number format code, and a preview of the number format code as applied to your active cell\u2019s value.\u00a0 Once you find the one you want, click Enter to apply it to any selected cells.\u00a0 You can also save the number format from the active cell to add to the library.<\/p>\n
When you want to reuse a custom number format that has been saved to your library.<\/p>\n
Custom number formats are extremely flexible and helpful, but can be tricky to set just right.\u00a0 This macro (and the related Bulk Edit Number Formats<\/strong> macro) allow you to easily save your custom number formats to a central library, where they are easy to access, reuse, and share with colleagues.<\/p>\n
None<\/p>\n\n
Number Format Picker
Toggle Number Formats
Number Format Shortcut<\/p>\n
None<\/p>\n
Add custom number formats to your library using the instructions below.\u00a0 Alternatively, add them to your library in bulk with the Bulk Edit Number Formats<\/strong>\u00a0macro (see below for instructions on the bulk edit approach).<\/p>\n
<\/strong>With custom number formats in your library, run the Search Number Formats<\/strong> macro.\u00a0 It will show you an auto-complete search box, and as you type, it will display custom number formats you can apply in your workbook, displaying the date last updated, the number format code, and a preview of the format applied to your active cell\u2019s value as you browse through the custom number formats matching your search.<\/p>\n
<\/strong>To manage your custom number format library, where you can add, edit, delete, review, or share the library, run the Bulk Edit Number Formats<\/strong> macro.\u00a0 It looks for the Bulk_Edit_Number_Formats<\/strong><\/span> sheet within your active workbook.\u00a0 If not found, it is added.\u00a0 Any existing custom number formats in your library will be displayed.\u00a0 Make any edits to the columns described below, then run the Bulk Edit Number Formats<\/strong> macro again to process your contents and save the custom number formats in the sheet to your library.\u00a0 These are the columns within the Bulk_Edit_Number_Formats<\/strong><\/span>\u00a0sheet to review or fill in:<\/p>\n\n
![\"\"](\"https:\/\/i0.wp.com\/excelevate.co\/wp\/wp-content\/uploads\/2025\/01\/Search-Number-Formats_Screenshot_2025-01-10-1.png?resize=877%2C534&ssl=1\")
![\"\"](\"https:\/\/i0.wp.com\/excelevate.co\/wp\/wp-content\/uploads\/2025\/01\/Search-Number-Formats_Screenshot_2025-01-10.png?resize=877%2C534&ssl=1\")