#19 OleStr cannot convert to Date

[Anonymous]

When I try to convert my XLS file into an XML file my column of dates forces an error box that says:

Could not convert variant of type (OleStr) into type (Date)

now, since I need these in the form of a date MM/DD/YYYY is there a workaround?