Format Cell - All Workbooks

[Guest]

I need your help because I cannot do the following:

Every time that I open Excel I want in all the workbook be the Number Cell
Format with 2 decimal for example I want to put 5.00 and in the cell give me
5.00 I changed the style but when I close Excel and open again I want the
same Style with 2 decimal do you know how to change that normal style with a
custom style.

ThankYou

 

[E Oveson]

Hi Billy,

Modify the normal style as you did, and then save the workbook in either:
(To have it be the default for everyone):
C:\Program Files\Microsoft Office\OFFICE11\XLSTART\Book.xlt (notice
extension is .xlt for template, and change 11 to your version if needed)
(To have it be the default for just yourself):
C:\Documents and Settings\[put username here]\Application
Data\Microsoft\Excel\XLSTART\Book.xlt

This, way, any new workbook will inherit that modified Normal style.

-Erik