Save a custom format for future use
 

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!

Save a custom format for future use
 

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


On Wed, 17 Dec 2008 07:26:43 -0800, K Cook
wrote:

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!

Save a custom format for future use
 

Thanks for the help. That answers my question.


"Gord Dibben" wrote:

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


On Wed, 17 Dec 2008 07:26:43 -0800, K Cook
wrote:

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!