Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format not working
I have a column of dates that are formatted like: 04/19/2009.
BUT I want them formatted as: April, 2009 I cright click and try to format the date but nothing happens? Why? How can I change the format of these dates? I am using Excel 07 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format not working
You'll have to change them from text to a date. Try Data/ Text to Columns/
and set the import format as MDY. -- David Biddulph "Stross002" wrote in message ... I have a column of dates that are formatted like: 04/19/2009. BUT I want them formatted as: April, 2009 I cright click and try to format the date but nothing happens? Why? How can I change the format of these dates? I am using Excel 07 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format not working
have you check if the 04/19/2009 is text? sorry for the question
hth -- pleae click yes if it was helpfull regards from Brazil Marcelo "Stross002" escreveu: I have a column of dates that are formatted like: 04/19/2009. BUT I want them formatted as: April, 2009 I cright click and try to format the date but nothing happens? Why? How can I change the format of these dates? I am using Excel 07 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format not working
Now that I went from 4/20/2010 to April-10 I still have a hard time filtering
my data. Eventhough it says April-10 it is still reading the day because the original date had the day in it. So it is filtering the days seperatly. If I have two dates: 4/19/2010 in row 1 and 4/20/2010 in row 2, I want to change their format to MM-YY so I would only count 1 but it is currently counting the two dates seperatly in my pivot table. Please help me.... "David Biddulph" wrote: You'll have to change them from text to a date. Try Data/ Text to Columns/ and set the import format as MDY. -- David Biddulph "Stross002" wrote in message ... I have a column of dates that are formatted like: 04/19/2009. BUT I want them formatted as: April, 2009 I cright click and try to format the date but nothing happens? Why? How can I change the format of these dates? I am using Excel 07 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DATE FORMAT NOT WORKING | Excel Worksheet Functions | |||
Date Format Not Working | Excel Worksheet Functions | |||
the date format is not working ,sort by date doesn't work. | Excel Discussion (Misc queries) | |||
changing date format not working | Excel Discussion (Misc queries) | |||
changing date format not working | Excel Discussion (Misc queries) |