Toad World® Forums

Formatting problem with Date when using "Export to Excel Instance"

Hello,

I'm currently using Toad for SQL Server 5.6.0.568 and i found a cosmectic problem when using "Quick Export > Excel Instance" from script editor results sets :

Datetime values are formatted on Excel's cells in "m/d/yyyy h:mm:ss" format which does not respect Windows regional settings (expected format : "dd/mm/yyyy hh:mm:ss").

See attachments
Regards,
Damien

Simple Query and result ok on Toad.jpeg

Windows XP regional settings (set to French).jpeg

Are you using French version of XP and Excel? What exact version of Excel is it? 2003, 2007 or 2010?

Are you using French version of XP and Excel? What exact version of Excel is it? 2003, 2007 or 2010?

I’m using Windows XP SP3 French and Office 2010 Professionnal Plus French