Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Date problem

3 views
Skip to first unread message

Guido Bos

unread,
Mar 13, 2010, 11:36:09 AM3/13/10
to
Hi all,

My dates in Excel are always recognized as M/D/YY.
Is there a way to change this default to D/M/YY?

Thanks for your help.
Guido

Daryl S

unread,
Apr 1, 2010, 1:51:01 PM4/1/10
to
Guido -

Excel will take the date entry and assume it is in the format that is the
default for your operating system. Change the format in your Mac OS, and
that should fix the issue.

--
Daryl S


"Guido Bos" wrote:

> .
>

Guido

unread,
Apr 20, 2010, 10:42:04 AM4/20/10
to
Strange,
In the system preferences it is indicated as Belgian Date format dd/mm/yy
but Excel keeps showing mm/dd/yy.

Anyone a clue ?

Thanks,
Guido


On 01/04/10 19:51, in article
75A9D12F-4D39-48DA...@microsoft.com, "Daryl S"

0 new messages