Toad World® Forums

TOAD - EXCEL INSTANCE

Dear Experts,

I have Toad 9.7.2.5 installed in my desktop. Recently I installed Microsoft Office Professional Plus 2010. Now when I use the data grid results to Excel Instance the date format is changing into numbers.

For example

If my grid result is 01-Feb-17

in Excel it comes like 42767

Previously when I had Excel 2007 I did not have this problem. Can any expert help me in this regard?

That version of Toad is really old. I don’t remember the specific cause of this - it may be your combination of Toad version and Excel version, or your system date format. Upgrading Toad should solve the problem, but if that’s not an option for you, then your best bet is to either use the “Excel File” format, or maybe you can format the cells back to a date in Excel (if you really want to use the Excel Instance format)