Years in dates showing up as YY

[theshusher]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Some of my dates are showing up with YY instead of the actual year. For example 1/5/YY instead of 1/5/09. When I key in a date from scratch, it doesn't do this, but when I import or copy/paste data it remains a problem (even though it recognizes the cell contents as a date).

Any clue?

I had a theory working that there may have been some conflict with my system regional settings. I had them set to China so the currency indicator was Y instead of $. I changed my regional settings back to US and my currency indicator to $ but I'm still having this problem.

Thanks.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Some of my dates are showing up with YY instead of the actual year. For
example 1/5/YY instead of 1/5/09. When I key in a date from scratch, it
doesn't do this, but when I import or copy/paste data it remains a problem
(even though it recognizes the cell contents as a date).

Any clue?

Where are you pasting from? What format are you importing?

I had a theory working that there may have been some conflict with my system
regional settings. I had them set to China so the currency indicator was Y
instead of $. I changed my regional settings back to US and my currency
indicator to $ but I'm still having this problem.

Did you restart XL after changing system settings? Did you try logging
out and logging in, or restarting your machine?

 

[theshusher]

Thanks for the help. I found I didn't properly readjust my regional settings in the system preferences. (I'm new to Mac.) Once I logged off and logged back on after that and reformatted the dates, they started showing up properly!

Of course I suppose it's a bug. I should be able to have my system preferences set to China and see dates properly.

 

[JE McGimpsey]

Of course I suppose it's a bug. I should be able to have my system
preferences set to China and see dates properly.

Probably not a bug, if you had your settings mixed.

XL's designed to take its input and default display settings from the
System Prefs (tho' you can format the displayed date however you wish).

And since it reads those settings when it starts up, you need to quit
and restart XL after changing the system settings.

If it's really failing when all date formats are set to China, then tell
MacBU by choosing Help/Send Feedback...