If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 . |
Thread Tools | |
Display Modes | |
|
|