Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
MS Office 2011 Date & Time format
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="macintush" data-source="post: 1498417" data-attributes="member: 255863"><p><strong>Solved: date format for Office 2008</strong></p><p></p><p><em>1. On your Mac, go to System Preferences; Language & Text [NOTE: **Mac** system prefs, NOT Word/Office prefs!]</em></p><p><em></em></p><p><em>2. Even if everything looks correct (ie, full, 4-digit year), under "Dates", click "Customize" and RE-set the "Medium", "Long", and "Full" date formats to the 4-digit year (eg, "2013") using the drop-down selection menu. Make sure the "Year" element (below the formats) shows all 4 digits (this doesn't seem to be changeable, but mine shows all 4 digits: "2013").</em></p><p><em></em></p><p><em>3. Click "OK"</em></p><p><em></em></p><p><em>4. Office now uses the 4-digit year when you "insert date".</em></p><p></p><p>Worked for me, using Lion (OS X 10.7.5) and Office:Mac 2008. I also had this problem appear out of the blue (red?) after upgrading from Snow Leopard (10.6.x) to Lion (10.7.x). Not sure if this will work for Office 2011 or Mountain Lion (10.8), but give it a try.</p><p></p><p>iMac (late 2006); OS X 10.7.5; Office:Mac 2008</p></blockquote><p></p>
[QUOTE="macintush, post: 1498417, member: 255863"] [b]Solved: date format for Office 2008[/b] [I]1. On your Mac, go to System Preferences; Language & Text [NOTE: **Mac** system prefs, NOT Word/Office prefs!] 2. Even if everything looks correct (ie, full, 4-digit year), under "Dates", click "Customize" and RE-set the "Medium", "Long", and "Full" date formats to the 4-digit year (eg, "2013") using the drop-down selection menu. Make sure the "Year" element (below the formats) shows all 4 digits (this doesn't seem to be changeable, but mine shows all 4 digits: "2013"). 3. Click "OK" 4. Office now uses the 4-digit year when you "insert date".[/I] Worked for me, using Lion (OS X 10.7.5) and Office:Mac 2008. I also had this problem appear out of the blue (red?) after upgrading from Snow Leopard (10.6.x) to Lion (10.7.x). Not sure if this will work for Office 2011 or Mountain Lion (10.8), but give it a try. iMac (late 2006); OS X 10.7.5; Office:Mac 2008 [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
MS Office 2011 Date & Time format
Top