Excel - inconsistent conversion of values
I am a recently appointed school governor. The LEA last year provided an Excel file for schools submitting budgets. There has been a problem because Excel has converted text values when using the plus sign (+), but has not converted text values when using @sum.
The school have asked me if they can take any further action as a result of this which has left them £30,000 short of funds. I do not have particular forensic skills to know how the values in two cells were entered as right aligned text values rather than as numbers.
However in the column two to the right where there was a formula using the value which used the plus sign there was no indication of the problem. The total of the column containing the cells used the @sum formula. Sadly it was this lower total which rippled through to the budget submission.
I can see that Microsoft have documented the conversion "If you enter a different type of value than is expected, Microsoft Excel sometimes is able to convert the value." Why isn't there consistency?
- AIA/Capital Allowances 135 4
- RTI and Advances to Employees 319 7
- Selling to USA, Delivery to Poland, VAT? 64 1
- HELP CT Return filed but doesnt match up HMRC's AP 167 6
- Stand alone practice management software 1,638 23
- International VAT 75 2
- CTA 172 2
- Office 365 vs. Google apps 593 9
- Anyone else experiencing issues with sage 50 payroll 691 21
- Insurance payout 95 1
- Non-UK resident - where to pay income tax? 520 11
- RTI / P11d 149 2
- Are any of you members of The Institute of Financial Accountants - Accountnats certificate 1,096 21
- Guaranteed rents - which is the turnover? 272 9
- Windows 7 to 8 should I go Excel or Office 365 369 3
- No more tax returns... 1,209 11
- Company Share Buy Back 282 7
- Sage 200 question 184 3
- P11d query 199 3
- How much state pension will client lose out if drops salary 356 5