Convert String to Date in Column

[brent_milne]

I have a column of dates from a MySQL database that are varchar. I need to be able to do a date range search on this column so I need to convert them to an excel date format but I haven't been able to find anything that really helps me. Right now the format is DD/MM/YYYY in Column C. I shouldn't have a problem doing the search, I just need a little help with getting them in the proper format. So to simplify my question: Convert a dd/mm/yyyy string to date ??

Thanks for any help.

[Norie]

Are you sure they are strings?

[Jakobshavn]

Give this a try:

Please Login or Register  to view this content.

[brent_milne]

Not 100% sure they are strings (listed as varchar in the MySQL database) but they show up in the columns as 08/02/2012 etc. If I try to do a sort on this column I can only do 'A-Z' but using the function from Jakob (DaterCNV) I can sort 'Oldest to Newest' .

[Norie]

Well it sounds like they were strings.

I just asked because I've imported dates from MySQL into Excel with no problem.

[Armando Montes]

This shows an easy way:
http://www.youtube.com/watch?v=HnphWTpmV8Y