Converting Text Date to Actual Date using VBA

Hello,

I have a text list that download's into my sheet into column B and the dates are in text format as dd/mm/yyyy, at present I'm using Text to Columns to convert it to an actual date.

Is there a way of doing this within VBA?

thanks reg

cDate(Your date value)

Be aware that if the text your are feeding to cDate is not really a date then this will cause an error.

Thanks Whizbang,

How do I use it in a macro or as Text to Columns??

thanks reg

Use it as a macro

Please Login or Register  to view this content.