Saving custom number format

[shantanuo]

1) I am trying to save a custom number format for e.g. ###,###,000.000
But when I open a new file this format is not available. Why doesn't it
gets saved? (excel 2002)

2) My home computer has recently been upgraded to the latest version of
excel. But I used to hit Alt + F and then C to close a file in earlier
versions. This no longer works! I have to hit Enter key after pressing
the "C". Is it a bug? or am I missing something?

Shantanu Oak

 

[Gord Dibben]

Custom formats are saved with the workbook.

To have these available for all new workbooks, save a blank workbook with the
custom formatting as a Template.

Use this template for all new workbooks.

Assuming latest version means Excel 2003, I cannot replicate your problem.

ALT + F + C closes the active workbook on my version of Excel 2003.


Gord Dibben Excel MVP

 

[Dave Peterson]

For #2...

Have you customized that File menu?

If you click on File, how many options do you see that use C as the accelerator
key (notice the C in Close is underscored).

If you have multiple options that use the same accelerator key, then this could
be the trouble.

You can change the accelerator key for the secondary options by:
tools|customize (just to see that dialog).

Find the options that have the same C accelerator key. Right click on it and
change the name--either remove the ampersand (&) or move it in front of another
letter.

&Close
means that C is the accelerator key for Close.

 

[shantanuo]

ok. Thanks for the info.
But what about the old files?

 

[Gord Dibben]

Can you spell "hooped"?

You will have to open old files, add the custom format then save.

Alternative.......record a macro to your Personal Macro Workbook while you add
the custom format.

Assign the macro to a button or shortcut key combo.

Save the Personal.xls as Hidden so's it will be available for all workbooks,
old or new.


Gord Dibben Excel MVP


Gord Dibben Excel MVP