I am having an issue when I export some qlikview files to excel. The excel output looks fine, however when I use the numbers in the excel output, sometimes the number isn't formatted as a number. It isn't a text either (multiplication by 1 does not force it to be a number).
It is as if the cell just "doesn't work"
Manually typing in the number into the excel file can fix the issue but there are no indications on where the issue occurs. (I only sumbled upon this when some cells weren't responding to my formulas against it)
Any advice would be greatly appreciated!
