Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Carla" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Format Problem - Date Overrides Format | Excel Discussion (Misc queries) | |||
Weird problem with conditional format | Excel Discussion (Misc queries) | |||
Weird dates appear in cells when I use Date format! Why? | Excel Discussion (Misc queries) | |||
Weird problem | Excel Worksheet Functions | |||
Weird Excel date formatting problem | New Users to Excel |