Reply to thread

Message

<blockquote data-quote="Slydude" data-source="post: 1726575" data-attributes="member: 131855">I think I understand why you are seeing two digit years rather than four digit years. Do the following and see if you then have the option for a four digit year setting.1. Open System Preferences and go to the Date &amp; Time preference pane.2. Make sure to click the Date &amp; Time tab.3. Click where it says Open Language and Region then select Advanced. . .4. In the next window/sheet that appears click the Date tab.5. In the lune that says &quot;Short&quot; there is a date filled in. The year is probably in two digit format. You should be able to change it to a four digit year.If I understand correctly you probably only need to do these steps once. I'm not sure if you will have to unlock the padlock on the preference pane. Now open Excel, right click a cell and choose Format. Now when you go to the Numbers tab and Date formatting the four digit year should be in the drop down list. If you select multiple cells before applying the formatting the change will be applied to all selected cells.</blockquote>

[QUOTE="Slydude, post: 1726575, member: 131855"] I think I understand why you are seeing two digit years rather than four digit years. Do the following and see if you then have the option for a four digit year setting. 1. Open System Preferences and go to the [B]Date & Time[/B] preference pane. 2. Make sure to click the [B]Date & Time tab.[/B] 3. Click where it says [B]Open Language and Region[/B] then select [B]Advanced. . . [/B]4. In the next window/sheet that appears click the [B]Date tab[/B]. 5. In the lune that says "Short" there is a date filled in. The year is probably in two digit format. You should be able to change it to a four digit year. If I understand correctly you probably only need to do these steps once. I'm not sure if you will have to unlock the padlock on the preference pane. Now open Excel, right click a cell and choose Format. Now when you go to the Numbers tab and Date formatting the four digit year should be in the drop down list. If you select multiple cells before applying the formatting the change will be applied to all selected cells. [/QUOTE]

Verification

Name this item. 🍎