date format



Hi All,
hopefully a quick question, from a novice.
Using Excel 2003 when setting the cell format to 'date' I am offered
mm/dd/yy. I would prefer to see dd/mm/yy. My regional setting is set to UK
and the regional options displays dd/mm/yy, but excel does not. Any help
gratefully received

מיכ×ל (מיקי) ×בידן

At the format window, take a look at the 'your area (location)' - it should
read English (Britain).

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