Only a handful of the dates are recognised by excel as dates, the rest are recognised as text. No matter what I try in excel I can't get the Zoho date fields to show as dates.

This stops sorting ability as well as creating charts and formulas.

This only happens with Zoho reports that are extracted. It's made even worse in that only "half the fields" have this problem.

See the attachment. Really need a fix!