Date Format

M

Martin Knight

Every time I type in the date it uses it for the year. I have my cells
formatted for US 10-Nov-2007 but if I type Nov 10 it puts 1-Nov-2010 and if
I type Nov 20 it puts 1-Nov-2020

Any ideas how to get a simple Nov 10 to insert Nov 10-2007
 
S

Shane Devenshire

Hi,

Are you in the US and is your country setting US?

On my machine typing Nov 10 works to enter 10-Nov and if I then format it to
your format it is correct.

Try typing 11/10. or 11-10 Nov-10

Sincerely,
Shane Devenshire
Excel MVP
 
R

Ron Rosenfeld

Every time I type in the date it uses it for the year. I have my cells
formatted for US 10-Nov-2007 but if I type Nov 10 it puts 1-Nov-2010 and if
I type Nov 20 it puts 1-Nov-2020

Any ideas how to get a simple Nov 10 to insert Nov 10-2007
Click to expand...

Excel interprets the date input based on the short date format in Windows
Regional Settings (under Control Panel) -- not based on how you format the
Excel cell.

You will either need to change that format, or make an unambiguous entry that
includes the year.


--ron
 
M

Martin Knight

Even though I live in Canada when I changed it from English Canada to
English US it works correctly. Didn't realize the Canadian format is so
screwy. Thanks.
 
R

Ron Rosenfeld

Even though I live in Canada when I changed it from English Canada to
English US it works correctly. Didn't realize the Canadian format is so
screwy. Thanks.
Click to expand...

You're welcome. Glad to help.

Most of the world would claim it is the US format that is screwy, though! :))
--ron
 
Top