Copy custom number formats from one sheet to another

[mawallace]

I have a custom number format which I use in most of my workbooks.

Normally I will define it in each workbook.

Is there a way that I can make that custom format available in all workbooks and / or in my default worksheet?

 

[Joe4]

You could create a macro that applies your custom format to the selected range (whatever that may be).

For example, your code may look something like this:

Sub MyCustomFormatMacro()
    Selection.NumberFormat = "mmm-dd-yy"
End Sub

Then, if you save this VBA code to your Personal Macro workbook, it will be available to you whenever you have Excel open on your computer.
So, you could then just select whatever range you want to apply it to, and run the macro.

Alternatively, if you are always applying it to the same range, maybe look at creating an Excel template that is already pre-formatted for you?

Anyway, those are a few options that hopefully help.

 

[mawallace]

Thank you - is there a way to do this without coding? The range is not always the same

 

[Joe4]

If you follow the method I proposed, it does not matter which range you want to apply it to.
You would just select whatever range you want to apply it to, and then run the macro (note in my code, I am using "Selection" instead of a definite range, so it will run against whatever is the selected range at the time).

If you want to see if you can use a non-VBA solution, have a look here, and see if any of these suggestions work for you: How to save and apply custom number formats in Excel?