Convert Scientific notation to Number format using Macro to export to excel

[Anonymous]

Hi All,

In Qlikview , I have converted all values into number. But When am exporting same to excel using macro still its showing in Scientific notation.

In chart, I have used function to convert exponential notation to number

=if(isnum(ReqNumber)=-1, num(ReqNumber,'#############0'), ReqNumber). Now in Qlikview its changed i.e all it is showing in number format.

But in Excel while exporting using macro,it is showing 1.5E + 12.

Can anyone please help me how to implement using macros?

Regards,

Nisha.