Exporting to Excel

[hopkinsc]

Hi, i have a problem when exporting into Excel.

I have used the following expression..

When i export this to excel, it exports as text even though i have stated the number format above.

The expression is set at default on the number tab as the above expression included currency and percentages.

Can anyone help please?

Sorry about the rubbish image above. I am at a clienst site and cant seem to copy and paste text from their Qlikview server!