Date Format

D

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

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.
 
Top