Wrong date format in MS Office 2008 for Mac

I have a Client using PowerPoint in Microsoft Office 2008 (12.0.0) on a Mac.

If she wants to insert the date from "insert" it only allow her to insert it like MM/dd/yyyy (that is US format).

If she opens a document where "current" date was inserted and set to automaticly update it also has det "month first" format.

I am unable to locate any settings in Offce where the date format can be changed.
In Systems settings for the Mac OS X 10.7.5. everything seems OK here the format is dd/mm/yyyy

On windows I would simply change the Regional settings in the control panel, which would change the format i Office, but it seems it is different on a mac.
Rybicki-IbsenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sigurdur ArmannssonDesigner Commented:
Office is getting the date information from the System, adjusted in the System Preferences/Language & Text. See the tabs Language first and Formats. It is very similar to the Regional settings on Windows.

In the Finder the dates on folders and files are (should be) in the way you set it in the System Preferences. And in Powerpoint it should be the same.

To start with you can set the primary language in the System Preferences/Language. You should have your local language at top but you can also have English at top and Dansk below.

Secondly, if you move to the Formats part it should show the settings for the primary language but in the Customize… button you can make your own favourite settings. You can swap the order of the dates and you can exchange the / slashes and have periods instead if you like.

That said, check first the settings in System Preferences and see if your settings are reflected in the Finder. If not, you might have to fix something there but lets tackle that later if you are not getting things fixed this way first.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rybicki-IbsenAuthor Commented:
Hi Sigurdur

Thanks for your input.

I did actually go into System Settings, but here the format and language seem right. Set to Danish and with the date format dd/mm/yyyy.

I did also do a test where I changed the date format, to see if the changes where reflected in powerpoint, but the changes did not change the behaviour of Powerpoint.

It seems to me that Powerpoint is not getting the settings from the system preferences.
0
Sigurdur ArmannssonDesigner Commented:
Did you log out and in again when you changed the format?

This is a bit odd. I am using a newer version, 2011 so I can't test this fully, but as I remember it the date formatting was the same in 2008.

In the Master slide, selecting the date and going to Insert>Date and Time, are all the options in the wrong format?

Check out this article: http://www.indezine.com/products/powerpoint/learn/interface/headers-footers-ppt2011-mac.html
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Rybicki-IbsenAuthor Commented:
I will check up on that. But I am pretty sure that all the formats for inserting a date was in the "wrong" order.

And changing the system settings (which where right from the beginning (dd/mm/yyyy)) did not impact PowerPoint at all.

Please let me check once again. I will try to get some screen shots.
0
Rybicki-IbsenAuthor Commented:
Here are the available options for insert date in Powerpoint

Insert date in PowerPoint
And here the System Settings options - where the format seems right

Systems settings on the Mac
0
Sigurdur ArmannssonDesigner Commented:
The system is definitely not talking to PP or PP not listening.

How are the other Office apps doing? Word for example?
Can you try on that computer to add a new account, open PP and see if it is right there or wrong?
Also: Check out this: http://www.textndata.com/forums/date-format-88363.html
0
Rybicki-IbsenAuthor Commented:
Very strange when going into Word - it seems the date format is correct

Insert date in Word for Mac
0
Sigurdur ArmannssonDesigner Commented:
Try to copy the date from Word to the Master Slide in PP as described in: http://www.textndata.com/forums/date-format-88363.html

Would be interesting if that works.
0
Rybicki-IbsenAuthor Commented:
Tried to copy paste, but with same results. I guess its is right, what others write about Office 2008 for Mac. That the date format somehow is hard-coded into PowerPoint. So there is not a great lot to do.

Thanks Sigurdur for answering - I will close the case.
0
Sigurdur ArmannssonDesigner Commented:
Ok. Maybe update to 2011?
0
Rybicki-IbsenAuthor Commented:
Yes I guess that would be a good idea any way.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.