Date Format

[Dee]

I have a spreadsheet that I want the date to be formatted
as day/month/year (13-09-03). I go to format cells and
choose that format for my column. When I type in the date
as 13/09/03 it will not convert the date to the correct
format. However if I type in 09/13/03 Excel will convert
to the proper format. Does this have anything to do with
my regional settings in Windows. Would I have to change
the setting to day/month/year in windows. I am using Excel
2000.

Thanks in advance for your help.

Regards,

Dee

 

[J.E. McGimpsey]

Number format affects display only, not how XL parses an entry.

To change the parser's interpretation of your entry, you'd need to
make a change in the regional settings.