I have my query set so that all the KF have to be shown with two decimals. When i execute the query it displays it perfectly. But when i execute the workbook to which my query is attached, it displays the numbers as it wishes: one column with 1 decimal, other with 6 and the other with 3.
Why would it do so?
I tried to delete the query and insert it again, but no luck..