ExcelBanter - convert dates stored as text to dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - convert dates stored as text to dates (https://www.excelbanter.com/excel-programming/318356-convert-dates-stored-text-dates.html)

lenko

convert dates stored as text to dates

What is the VB code to convert dates stored as text to excel formatted dates?

Bob Phillips[_6_]

convert dates stored as text to dates

Something like

cdate("12 sep 2004")

--

HTH

RP
(remove nothere from the email address if mailing direct)

"lenko" wrote in message
...
What is the VB code to convert dates stored as text to excel formatted
dates?

Tom Ogilvy

convert dates stored as text to dates

ActiveCell.Value = ActiveCell.Value
ActiveCell.NumberFormat = "mm/dd/yyyy"

--
Regards,
Tom Ogilvy

"lenko" wrote in message
...
What is the VB code to convert dates stored as text to excel formatted
dates?

All times are GMT +1. The time now is 10:28 AM.