Export to Excel - Keep Number Format

[#1]

Hi I have a variable to calculate a percentage for a pivot chart :

num(sum(Number)/sum([Line Total]),'#,##0.0%')

When I try to export the pivot to Excel all the numbers are formatted as text.  How can I keep the number format??

Many thanks,

Tom