-Ron-
asked on
Setting the date system (1900) on Mac Office 2008
How do you set the date system 1900 vs 1904 on Mac Office 2008?
See if this helps: http://office.microsoft.com/en-ca/excel/HP100541411033.aspx
XL uses the date system of the first workbook that is opened, so you can
do this by setting up a default workbook. See the "default workbook
template" topic in XL Help.
Specifically, create a new workbook. Arrange it the way you want (e.g.,
number of worksheets, formatting). Set the date system to 1900. Save the
workbook as a template with the name "Workbook" (no quotes, no
extension" in your Startup directory (by default, the
HD:Applications:Microsoft Office 2004:Office:Startup:Excel:
do this by setting up a default workbook. See the "default workbook
template" topic in XL Help.
Specifically, create a new workbook. Arrange it the way you want (e.g.,
number of worksheets, formatting). Set the date system to 1900. Save the
workbook as a template with the name "Workbook" (no quotes, no
extension" in your Startup directory (by default, the
HD:Applications:Microsoft Office 2004:Office:Startup:Excel:
yours of course would be
HD:Applications:Microsoft Office 2008:Office:Startup:Excel:
HD:Applications:Microsoft Office 2008:Office:Startup:Excel:
ASKER
This is good information - but only shows how to change in the Windows program - I need to have a Mac user change on the Mac side but I don't have a Mac handy to look at the options -but evidently the options are not the same as those described for the Win Excel
ASKER
Thanks Philip
Exactly how do you -"Set the date system to 1900"?
XL uses the date system of the first workbook that is opened, so you can
do this by setting up a default workbook. See the "default workbook
template" topic in XL Help.
Specifically, create a new workbook. Arrange it the way you want (e.g.,
number of worksheets, formatting). Set the date system to 1900. Save the
workbook as a template with the name "Workbook" (no quotes, no
extension" in your Startup directory (by default, the
HD:Applications:Microsoft Office 2004:Office:Startup:Exc
Exactly how do you -"Set the date system to 1900"?
XL uses the date system of the first workbook that is opened, so you can
do this by setting up a default workbook. See the "default workbook
template" topic in XL Help.
Specifically, create a new workbook. Arrange it the way you want (e.g.,
number of worksheets, formatting). Set the date system to 1900. Save the
workbook as a template with the name "Workbook" (no quotes, no
extension" in your Startup directory (by default, the
HD:Applications:Microsoft Office 2004:Office:Startup:Exc
Sorry about that. Try this link instead: http://support.microsoft.com/kb/214330
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.