| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
| Conditional format for future date | Excel Discussion (Misc queries) | |||
| How do I retain/save my data sort for future use ? | Excel Discussion (Misc queries) | |||
| How do I save a custom cell format that I created? | Excel Worksheet Functions | |||
| Custom Cell Format Will Not Save Correctly | Excel Worksheet Functions | |||
Linear Mode
