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 |
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 |
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 |
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 . |
All times are GMT +1. The time now is 01:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com