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?
- Xerocon 2016 1,019 24
- Entrepreneurs' Relief upon sale of a cash rich company 2,192 41
- buying asset and settling vendor's debt 236 6
- Posting invoices with balance brought forward 250 7
- HMRC now overriding SA bank repayment details on tax returns 598 12
- Personal Tax 499 11
- USA Tax Query 175 1
- Disengagement Help! 1,661 25
- Is HMRC Basic Tools basically wrong? 946 6
- Expenses paid by director (the comapny owner) 299 2
- Write an article on latest tax changes for landlords. 602 18
- Corrupt Excel File 674 10
- Website costs (intangible assets) tax relief 353 4
- Is Xero payroll as rubbish as I suspect it is? 1,975 43
- Locked Out of HMRC Online Account - HMRC Not Responding 290 2
- Re-Training costs - tax reief 415 7
- Capital Gain on Share Disposal with Held Over Gains 180 1
- 64-8's amazingly quick 344 4
- last minute request 523 5
- VAT - Check on clients business 1,254 46