Thursday, December 13, 2012

How to Convert a Mac Date System to Excel


1. Open the Excel file that contains the cells with incorrect dates.
2. Click on any empty cell. Type '1462' into this cell, as this signifies the number of days between the two date systems. Right-click the cell and choose 'Copy.'
3. Select the cells that contain the incorrect dates. To select multiple cells, click and hold on the top left cell in a range and then drag your mouse to the bottom right cell. Hold the 'Ctrl' button to select ranges that aren't adjacent to each other.
4. Right-click on any of the selected cells. Move your mouse over 'Paste Special' in the first pop-up menu that appears, and then click on 'Paste Special' that appears at the bottom of the second pop-up menu. This brings up the 'Paste Special' window.
5. Click the radio button next to 'Add' in the 'Operation' area of the window and click 'OK.' The selected dates will shift up by 4 years and a day.

Blogger news