Inputting date as dd/mm not mm/dd

M

MichaelH

I have just re-installed office 2003 and my date input order is no mm/dd.
In an existing spreadsheet I always used to type eg 8/6 for 8 June. Now it
interprets it as 6 Aug. How can I set it to interpret input as 8 June
My regional settings have dd/mm/yyyy for short date.
Thanks
 
R

Ron Rosenfeld

I have just re-installed office 2003 and my date input order is no mm/dd.
In an existing spreadsheet I always used to type eg 8/6 for 8 June. Now it
interprets it as 6 Aug. How can I set it to interpret input as 8 June
My regional settings have dd/mm/yyyy for short date.
Thanks
Click to expand...

This behavior is controlled by your Windows Regional Settings date format
(accessed via the Control Panel).

Somehow the date format got changed to "mdy" from "dmy". Possibly had nothing
to do with the reinstallation of office.

In any event, go to Start/Control Panel and access your regional settings and
make the appropriate changes there.
--ron
 

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

Similar Threads

Forcing a date entry format of dd/mm/yyyy 1
Date Formats 4
How to enter a date in DD-MM-YYYY format 2
Returning the month (mmm) from cell in date format dd/mm/yyyy 3
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 3
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1
convert Julian date to DD/MM/YYYY 8
yyyy-mm-dd date format? 3

Top