Save a custom format for future use

[K Cook]

I frequently use the same custom number format in spreadhseets. Is it
possible to save this format so that it is available to select from the
custom format list instead of having to re-type each time?? Thanks!

 

[Gord Dibben]

Custom formats are workbook-specific and saved with that workbook only.

You could add a macro to your Personal.xls to set the Custom Format.

Assign that macro to a button or shortcut key.

Examples...............................

Sub Leaders()
Selection.NumberFormat = "@*."
End Sub

Sub sq_Meters()
Selection.NumberFormat = "0"" m" & Chr(178) & """"
'0179 for cubic meters
End Sub


Gord Dibben MS Excel MVP

 

[K Cook]

Thanks for the help. That answers my question.

Custom formats are workbook-specific and saved with that workbook only.

You could add a macro to your Personal.xls to set the Custom Format.

Assign that macro to a button or shortcut key.

Examples...............................

Sub Leaders()
Selection.NumberFormat = "@*."
End Sub

Sub sq_Meters()
Selection.NumberFormat = "0"" m" & Chr(178) & """"
'0179 for cubic meters
End Sub


Gord Dibben MS Excel MVP