cad format in excel

[idogridish2]

hi everyone,

i can't sum cad currency when i export my data to excel

but dollar and euro are ok.

i am using num formating in qlikview with CAD #,##0 ;CAD -#,##0

and the solution in the pdf attached is just not good enough..

Thanks in advance.