Save a custom format for future use

  • Thread starter Thread starter K Cook
  • Start date Start date
K

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!
 
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
 
Thanks for the help. That answers my question.


Gord Dibben said:
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
Click to expand...
 
Back
Top