Everything works good on qlikview, but when I pull out the data to excel, it does not read the numbers with pound sign as number, but as text so I can not do any calculation with this number. The numbers with dollar and euro signs work good.
I tried diferent thing on excel to reformat cells but it does not work.
Anybody any thoughts what causing the prblem with the pound sign?
Formating-function are generally difficult by exporting to excel because than excel interpreted the values on a own logic which is often not wanted. You could convert these values manually or per macro but easier will be to use two columns - one with value and one with the currency.