How do I permanently save a custom number format in Excel?

Adrh_23 

If you want to apply a custom number format without using VBA, you can still achieve it using Excel's built-in functionality.

Here's how you can do it:

1. Select the cells to which you want to apply the custom number format.
2. Right-click on the selected cells and choose "Format Cells" from the context menu.
3. In the Format Cells dialog box, go to the "Number" tab.
4. Select the "Custom" category.
5. In the "Type" field, enter your desired custom number format. For example,                               you can enter "dd° mm' ss''" for degrees, minutes, and seconds.
6. Click "OK" to apply the custom number format to the selected cells.

The selected cells will now be formatted with your custom number format.

This method doesn't require VBA and allows you to apply the custom number format directly using Excel's user interface. The formatting will be applied to the selected cells and will persist until you change it. You can use this method in any workbook without the need for VBA code.

OR…you can use VBA to apply a custom number format to cells in Excel.

Here's an example of how you can do it:

Sub ApplyCustomNumberFormat()
    Dim customFormat As String
    customFormat = "dd° mm' ss''" ' Replace with your desired custom number format
    
    ' Apply custom number format to selected cells
    Selection.NumberFormat = customFormat
End Sub

Here's how to use this VBA code:

1. Press Alt+F11 to open the VBA editor.
2. Insert a new module by clicking "Insert" > "Module."
3. Copy and paste the above VBA code into the module.
4. Replace "dd° mm' ss''" with your desired custom number format inside the customFormat variable.
5. Close the VBA editor.
6. Select the cells to which you want to apply the custom number format.
7. Press Alt+F8 to open the "Macro" dialog box.
8. Select the "ApplyCustomNumberFormat" macro and click "Run."

The selected cells will now be formatted with your custom number format.

You can assign the macro to a button or a keyboard shortcut for easier access. To do this, right-click on the button or go to "File" > "Options" > "Customize Ribbon" to assign a keyboard shortcut.