1900 date system as a preference in new files

C

Clovis

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Is there a way to automatically set new files for the 1900 date system? I use Leopard.
 
C

CyberTaz

One Option: You can create your own custom default workbook by following the
steps outlined in Excel Help:

[Change the format and settings for new workbooks]

Create a workbook that contains the sheets, default text (such as page
headers and column and row labels), formulas, styles, custom number format,
and other formatting that you want to appear in all new workbooks.

On the File menu, click Save As.

On the Format pop-up menu, click Excel Template (.xltx).

In the Save As box, type the name Workbook, and then *clear the Append file
extension check box*.

Click the arrow button , open Microsoft Office 2008/Office/Startup/Excel,
and then click Save.

You must quit and then reopen Excel to see the changes in a new workbook.

Note To restore original settings for workbooks, delete the Workbook file
from the Excel startup folder.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
J

JE McGimpsey

Just a couple comments:

CyberTaz said:
One Option: You can create your own custom default workbook by following the
steps outlined in Excel Help:

[Change the format and settings for new workbooks]

Create a workbook that contains the sheets, default text (such as page
headers and column and row labels), formulas, styles, custom number format,
and other formatting that you want to appear in all new workbooks.

On the File menu, click Save As.

On the Format pop-up menu, click Excel Template (.xltx).

In the Save As box, type the name Workbook, and then *clear the Append file
extension check box*.

Click the arrow button , open Microsoft Office 2008/Office/Startup/Excel,
and then click Save.

I recommend saving it in an alternate startup folder (which you specify
in Preferences/General). This has two advantages...

1) Saving user files in the Application Folder Hierarchy is
non-standard, and could lead to losing the file if you ever do a
Remove/Reinstall.

I created an XL08START folder in the

~:Library:Application Support:Microsoft:Office:

folder. That way, if I ever blow away Office, my templates will be safe.

2) Saving the file in the Application folder hierarchy will, by default,
be used by all users on your Mac. This can lead to confusion if there
are multiple users of your machine, and less fine control if you have
multiple accounts set up for different purposes.
You must quit and then reopen Excel to see the changes in a new workbook.

That *shouldn't* be necessary...
Note To restore original settings for workbooks, delete the Workbook file
from the Excel startup folder.

To temporarily reset - start XL with the Shift key down.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top