Thread: convert dates stored as text to dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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?


Reply With QuoteReply With Quote