Formatting Number

  • Thread starter Thread starter Michelle B.
  • Start date Start date
M

Michelle B.

I created a custom format for persents, if the percent is
negative it has brakets around it, (5%).

However, it's only available in the workbook that I
created it in. I would like it to be available in every
excel file that I open, how do I do that?

Thanks
 
Hi,
One way would be to create a workbook file (book1.xls) and
format it the way you want. Headers and footers and other
custom formats. Then save it in the xlstart folder on
your c drive. Then every time you open excel this
workbook will open. You can either use it or close it and
open a new blank.

peter
 
I think I'd do almost everything Peter suggested, but I'd save it as book.xlt
(template). Then each workbook that you create would inherit this from that
template workbook.
 
Back
Top