Weird date format problem

  • Thread starter Thread starter Carla
  • Start date Start date
C

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