[Excel/SIMS] Interpreting Reg Groups as Scientific Formulae
Before I start writing a macro to correct this (which will be a total PITA as it'll have to be applied to every report in the system!), does anybody know how to stop Excel automatically formatting cells?
The problem I'm having is that some of our Reg groups contain the letter 'E' followed by a single number (e.g. 10E1, 9E2, 8E1 etc.). When you run a report from SIMS and set the output to Excel, Excel sees this and interprets it as a scientific forula so 10E1 becomes 100, 9E2 becomes 900 etc.