Forum Discussion
Solved
Convert Text to Date Format
Hello everyone, I'm just an excel newbie and I've been finding ways on how to convert a date text string to date format. I find it peculiar that after transferring all my CSV files through a flas...
Hi Nina,
you can use this macro, see attached file to convert dates. It converts all dates in selection to real date.
Sub KonvertDate()
Dim rngCell As Range
For Each rngCell In Selection
rngCell.Value = CDate(rngCell.Value)
Next rngCell
End SubBest regards from germany
Bernd
http://www.vba-tanker.com
Nina_SC ,
You may select your column, on ribbon Data->Text to Columns. On second step of the wizard select as delimiter any symbol which is not appears in you data
On third step select Date and MDY
It is assumed your default date format is m/dd/yyyy
Hi Sergei,
Thank you for your reply. I did what you have instructed but still no visible change though. Is there another workaround I could do?
Nina