sometimes i would like to export the result of my query from toad to ms excell
there , i have to every time to format the numbers , where always coming as currency format
i used those 2 formulas :
as number with no decimal places
to_char(100 * (PRV_SLS-PRV_EXP)/NULLIF(PRV_SLS,0) ,'fm9990.00')||'%'
to forrmat number as percentage with 2 dicimal places
it is ok in the result itself , but when exported to toad , i found that i need to again convert the strings to number
any way to direct convert as number