Re: [ExcelVBA] Excel Date format problem

 

attachments get stripped off so post the example in the files area

Thus I am guessing a solution as follows based on past experience
rather that your precise circumstances

you need to use a combination of trim(), left(), right() len() and
find() to convert your date entries into a format that datevalue()
will read in as a valid DDD/MMM/YYYY date, trim() can get rid of
spaces too

12-04-2001 would be converted using left() to grab the day, mid() to
grab the month and right() to grab the year, alternatively you could
save out the date data as a txt file and use the delimited option or
do "text to column" to place the three sets of numbers in different
columns

then you can sort on the basis of day() month() and year(), making
sure you sort all the columns including the ones with the formulae in

hope this helps, please email me a bit of data with comments added
for me to take a look at!

Regards

Dr B

On 5 April 2012 18:12, V.S. Ravi <vsravi_kmb@yahoo.co.in> wrote:
> 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]
>
>
>
> ------------------------------------
>
> ----------------------------------
> 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
>
> ----------------------------------Yahoo! Groups Links
>
>
>

--
===========================
http://uk.linkedin.com/in/drjohnbullas

__._,_.___

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

Messages in this topic (2)

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

.

__,_._,___