Cell date shows up in Excel for windows, not of Excel X for mac

[Darwin Oriondo]

A schedule xls file is sent to us by clients. Numerous cells have function
commands assigned to them to show the dates. These cells show the dates
when viewed in Office 2002 for PC. When I try to view the same file in
Office X SR-1 for Mac, I get ####'s instead of the dates that are suppose to
be in there. When I look at the function command for the dates, the pc
version is different from the mac version of the file. Changing the
function in the mac version to match that of the pc version will cause the
date to show up in mac, replacing the pound signs that was showing before.

i believe the excel file was created from a windows version of excel.

Has anyone else seen this problem before?

 

[JE McGimpsey]

A schedule xls file is sent to us by clients. Numerous cells have function
commands assigned to them to show the dates. These cells show the dates
when viewed in Office 2002 for PC. When I try to view the same file in
Office X SR-1 for Mac, I get ####'s instead of the dates that are suppose to
be in there. When I look at the function command for the dates, the pc
version is different from the mac version of the file. Changing the
function in the mac version to match that of the pc version will cause the
date to show up in mac, replacing the pound signs that was showing before.

i believe the excel file was created from a windows version of excel.

Has anyone else seen this problem before?

What are "the function command(s) for the dates" that are different?

There are no native date functions in WinXL or MacXL that have different
syntaces. Is this a User Defined Function?

Since WinXL97/00/02/03 and MacXL98/01/v.X/04 share the exact same file
format, there's no reason a formula would appear differently in one
version than another (aside from language, obviously, but that shouldn't
be an issue if both files are viewed on the same machine).

 

[JE McGimpsey]

A schedule xls file is sent to us by clients. Numerous cells have function
commands assigned to them to show the dates. These cells show the dates
when viewed in Office 2002 for PC. When I try to view the same file in
Office X SR-1 for Mac, I get ####'s instead of the dates that are suppose to
be in there. When I look at the function command for the dates, the pc
version is different from the mac version of the file. Changing the
function in the mac version to match that of the pc version will cause the
date to show up in mac, replacing the pound signs that was showing before.

i believe the excel file was created from a windows version of excel.

Has anyone else seen this problem before?

One other thought - have you tried widening the column(s)? Having
different default fonts/sizes may cause the date to overflow in the Mac
version. Reentering the function may cause the column to reset to the
correct width.

That wouldn't explain why a "function command...version for the pc is
different from the mac version", though.

 

[Darwin Oriondo]

resizing the cell boxed worked (widening the columns)! Once I did this on
the mac, the values changed to the same one as the PC and I was able to view
the dates. Thanks!

 

[Paul Hamburg]

I had the same problem, and it resolved by reducing the font size------