[ExcelVBA] Excel Date format problem

 

Hi,

I am having an excel file which I have converted from PDF to Excel. The problem I am having is the data on column D is not unique. When I changed to all data to date format I am getting only numeric values. I have tried copying into different column and change it to unique format, but it dosent help. Can I get guidance how to make unique date format so that I can filter by year then by month.

Excel file is attached for kind reference

Regards,

Ravi

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 8

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___