FORMAT Cells - Custom

Hello,
I'm using Excel97. When I format a cell, usually numbers, I want to
customize one of the existing formats under the 'custom' button. However,
the changes I make are not saved for me to use on any new or old spreadsheets.

Is there a way to save them?

Custom formats are saved with the workbook and are not available for others.

Open a new workbook. Customize as you wish. File>Save
As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook
"BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button File>New

Do not use File>New...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default Insert>Sheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP

On Fri, 21 Jul 2006 08:14:02 -0700, JHL <[email protected]> wrote:

>Hello,
>I'm using Excel97. When I format a cell, usually numbers, I want to
>customize one of the existing formats under the 'custom' button. However,
>the changes I make are not saved for me to use on any new or old spreadsheets.
>
>Is there a way to save them?

Gord Dibben MS Excel MVP

Thank you.
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:[email protected]...
> Custom formats are saved with the workbook and are not available for
> others.
>
> Open a new workbook. Customize as you wish. File>Save
> As Type: scroll down to Excel Template(*.XLT) and select. Name your
> workbook
> "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.
>
> Store this workbook in the XLSTART folder usually located at........
>
> C:\Documents and Settings\username\Application
> Data\Microsoft\Excel\XLSTART
>
> This will be the default workbook for File>New or the Toolbar button
> File>New
>
> Do not use File>New...Blank Workbook or you will get the Excel default
> workbook.
>
> Existing workbooks are not affected by these settings.
>
> You can also open a new workbook and delete all but one sheet. Customize
> as
> you wish then save this as SHEET.XLT in XLSTART folder also. It now
> becomes
> the default Insert>Sheet.
>
> More can be found on this in Help under "templates"(no quotes).
>
>
> Gord Dibben Excel MVP
>
> On Fri, 21 Jul 2006 08:14:02 -0700, JHL <[email protected]>
> wrote:
>
>>Hello,
>>I'm using Excel97. When I format a cell, usually numbers, I want to
>>customize one of the existing formats under the 'custom' button. However,
>>the changes I make are not saved for me to use on any new or old
>>spreadsheets.
>>
>>Is there a way to save them?
>
> Gord Dibben MS Excel MVP