Weird date format problem

[Carla]

Hi
Our minor hockey organization uses Excel 2007 to create hockey schedules.
for some reason the first half of the schedule has some kind of date format
in column A that shows the date as D/M/YY not matter how you enter it. Then
it changes to MM/DD/YY about 20 rows down and no matter how many different
ways I have tried to change the formatting it still comes out the same month
after month. I go back and reenter the d/m/yy dates to shows as mm/dd/yy but
it leaves off the preceding zero on the month and I have even try to use
paste formatting command to fix it and it doesn't change. Has anyone ever
heard of something like this?

 

[Jim Thomlinson]

As a guess the contents of your cells is text and not dates. As such
formatting does nothing to it. You need to convert the cell values to dates.

 

[Fred Smith]

I'll bet your cells are text, not dates. To get rid of a text cell, format
the cell to something other than text (like the date format you want), then
re-enter it. Just reformatting isn't sufficient.

Regards,
Fred