Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dates in Mac version of excel

Dates in Mac version of excel

ResolvedVersion 2008 (Mac)

Fri 26 Feb 2010, 16:04 Delegate Sue said...

Sue has attended:
Project Intro Intermediate course
Excel Introduction course
Access Introduction course
Excel Intermediate course
Excel Advanced course
Access Introduction course
Outlook Advanced course

Dates in Mac version of excel

can you tell me how to format the dates in the Mac version of Excel so that they carry over properly when a pc generated file is opened on a Mac

Mon 1 Mar 2010, 11:05 Trainer Anthony said...

RE: dates in Mac version of excel

Hi Sue, thanks for your query. You've identified a known issue with the Mac version of Excel. I have a solution which, sadly, I can't claim to be my own! The following link should explain all:

http://www.185vfx.com/2008/03/excel-dates-incompatible-from-pc-to-mac/

Hope this helps,

Anthony

Mon 8 Mar 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips

Dates in Mac version of excel

Dates in Mac version of excel

RE: dates in Mac version of excel

Excel articles

Excel tip:

Adding a comment to a formula