Date Format

  • Thread starter Thread starter Dee
  • Start date Start date
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
 
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.
 
Back
Top