Hi, I've hit an excel issue with the Sum() function. When I use it on the data i get e.g. £ - but if I add the cells manually it works. Please see below image for what the issue looks like. I've tried various combinations on the template/QV document of number/currency etc.
this is a screen shot taken from the previewed template.