What is the VB code to convert dates stored as text to excel formatted dates?
B Bob Phillips Dec 5, 2004 #2 Something like cdate("12 sep 2004") -- HTH RP (remove nothere from the email address if mailing direct) lenko said: What is the VB code to convert dates stored as text to excel formatted Click to expand... dates?
Something like cdate("12 sep 2004") -- HTH RP (remove nothere from the email address if mailing direct) lenko said: What is the VB code to convert dates stored as text to excel formatted Click to expand... dates?
T Tom Ogilvy Dec 5, 2004 #3 ActiveCell.Value = ActiveCell.Value ActiveCell.NumberFormat = "mm/dd/yyyy" -- Regards, Tom Ogilvy lenko said: What is the VB code to convert dates stored as text to excel formatted Click to expand... dates?
ActiveCell.Value = ActiveCell.Value ActiveCell.NumberFormat = "mm/dd/yyyy" -- Regards, Tom Ogilvy lenko said: What is the VB code to convert dates stored as text to excel formatted Click to expand... dates?