PDA

View Full Version : Excel: to populate date properly under a month



sarat
12-21-2012, 02:10 AM
Hello fnds,

In the attached excel sheet, how can I set the parameter so that date for a particular month will be displayed cumulatively.

If you check the date 21/12/2012, it should be comes under month ''DEC" in the filter button. But its displayed separtely in a single row.

How to resolve so that all dates will comes under their respective month.


Advance thanks

xld
12-21-2012, 03:44 AM
Select the whole column, and do a Data>Text To Columns on that column and just hit Finish.

sarat
12-21-2012, 05:50 AM
Thanks Xld,
As you said, I did the same process but the issue is still there.

xld
12-22-2012, 03:21 AM
I did it on your file, and it fixed the problem nicely.

sarat
12-22-2012, 05:36 AM
Hello Xld,
sorry to bother u once again.

If you have a look on the date for month Decemeber in the spreadsheet retrievd from database, then available dates available are 21/12/2012 11:58:35, 14/12/2012 10:28:29, 19/12/2012 8:54:46.



But when I select the month "Dec" through filter, only the date '7' is displayed (but not 21/12,14/12 and 19/12). Can I use any function so that all the dates will be populated under a particular month.

Thanks..

david000
12-22-2012, 12:11 PM
But when I select the month "Dec" through filter, only the date '7' is displayed (but not 21/12,14/12 and 19/12). Can I use any function so that all the dates will be populated under a particular month.

I'm guessing that Excel doesn't filter by Month in that format. What you can do is use the text-to-columns delimiter option for "other" and type in "/" then separate the dates into their own columns; like 21 | 12 | 2012 that will allow you to sort by month. I opened your example and was able to do that no problem.