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

Jim Thomlinson


"Carla" wrote:

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?