Is it possible to use numbers that have a thousand separator in Excel for advanced rules. The rule seems to work fine until I apply the thousand separator in Excel and apply the new data, at which point it returns a blank space (no figure).
Sorry - should have said, I'm trying to use HP...