Weird date format problem

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?
 
J

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top