Number Format

D

Dewayne

I use several number formats that include text. I have only been able to
access those formats from the workbook in which they were created. Is there
a way to have these custom formats available in all workbooks? Currently I
have to copy/paste the format from 1 workbook to another or recreate them in
each workbook.
Thank you for any suggestions.
 
J

Jim Rech

There is no special Excel feature to share number formats among workbooks.
Copy/paste is good way to go. Also you might have a default
workbook/template that has the number formats you want, that you could use
as the starting point for each new workbook.

I should add that with Excel's Format, Style feature you can created named
custom styles (that can include number formatting among many other
formatting characteristics). You could create a "MyFavFormat" style for
instance that has a particular number format. Then in another workbook you
could import that style with Format, Style, Merge.

--
Jim Rech
Excel MVP
|I use several number formats that include text. I have only been able to
| access those formats from the workbook in which they were created. Is
there
| a way to have these custom formats available in all workbooks? Currently
I
| have to copy/paste the format from 1 workbook to another or recreate them
in
| each workbook.
| Thank you for any suggestions.
| --
| Dewayne
 
Top