Date Formatting Error

C

Cookie

A colleague of mine has a spreadsheet with various dates in them in the
format dd/mm/yyyy.

Some of the dates where the day is less than 13 keep toggling between
displaying dd/mm/yyyy and mm/dd/yyyy, however, if they are formatted as
dd-mmm-yyyy they display the correct date and month.

This only seems to happen on the pc at work and not at home which implies
some configuration issue.

I have seen this problem before myself but never got to the root cause, does
anyone out there have a reason and hopefully a resolution to this issue?

Thanks
David
 
C

Cookie

Hi,

Both pc's have the regional settings for the short date set to dd/MM/yyyy.

Thanks
David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top