Solved

Wrong date format in MS Office 2008 for Mac

Posted on 2014-07-29
11
871 Views
Last Modified: 2014-08-11
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.
0
Comment
Question by:Rybicki-Ibsen
  • 6
  • 5
11 Comments
 
LVL 22

Accepted Solution

by:
Sigurdur Armannsson earned 500 total points
ID: 40228632
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
 

Author Comment

by:Rybicki-Ibsen
ID: 40238268
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
 
LVL 22

Expert Comment

by:Sigurdur Armannsson
ID: 40238801
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
 

Author Comment

by:Rybicki-Ibsen
ID: 40240696
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
 

Author Comment

by:Rybicki-Ibsen
ID: 40240802
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 22

Expert Comment

by:Sigurdur Armannsson
ID: 40241805
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
 

Author Comment

by:Rybicki-Ibsen
ID: 40245777
Very strange when going into Word - it seems the date format is correct

Insert date in Word for Mac
0
 
LVL 22

Expert Comment

by:Sigurdur Armannsson
ID: 40245880
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
 

Author Comment

by:Rybicki-Ibsen
ID: 40252548
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
 
LVL 22

Expert Comment

by:Sigurdur Armannsson
ID: 40252642
Ok. Maybe update to 2011?
0
 

Author Comment

by:Rybicki-Ibsen
ID: 40252648
Yes I guess that would be a good idea any way.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this article we will discuss some EI Capitan Mail app issues and provide some manual process to resolve them.
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now