I’m QA so I just use Toad to get data to verify in my tests
I have a query that I export to a spreadsheet using the Export to Excel Instance. after putting in lots of formulas to perform calculations after i then verify that my calculated column = the value exported from Toad.
I added this to my toad query thinking it would add the formula automatically to verify the two columns are the same but the formula in that column has a
before it so I have to edit the cell to remove that before it can be used as an actual formula.
How can I prevent the export from adding that backtick?