Exporting to Excel Query

[hopkinsc]

Hi,

Can anyone tell me if there is a way of exporting to excel in the correct format?

Everytime i export to excel, there are some columns that i have to manually convert to a number format.

The columns with green triangles i have to convert to a number format.

thanks

[Nicole-Smith]

If you change the format of the expressions on the Number tab in Qlikview to one of the number formats, they should export to excel as numbers.  You could also use =Num() around your fields or dimensions/expressions to make sure the format of it is a number.