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?
- Best Tax / Accounts Production software 1,028 18
- Summer festivals! 223 6
- Overlap profit 362 8
- VAT on Security Services to Foreign Companies. 88 3
- NHS England and the Off Payroll Worker Team 136 3
- Do accountants work at home? 651 13
- I used to think HMRC contact lines couldnt get any worse................ 332 5
- Can I pay into a pension? 177 3
- The Accountancy Party: What’s in your manifesto? 186 4
- Personal Expenses 218 5
- Furnished Holiday Lets & VAT 154 6
- Moneysoft or Sage payroll with auto enrolment? 473 10
- Accountants Qualifications 312 3
- SPORTS SUPPLEMENTS 89 1
- US Company charging VAT. How to account 167 2
- PPR for transferee spouse 89 1
- Rogue Accountant 3,973 58
- Where has Portia gone? 6,249 120
- How to introduce funds in to a Limited by guarantee company 89 1
- ER Relief 122 2