21/04/2015 P.C 296 Repairs and maintenance OFFICE PADLOCK − Anuarite
Above is how it reflects in my petty cash : date, voucher number, account, description.
Kindly explain to me what the “&minus” means because in my entry i just indicated OFFICE PADLOCK but on going through my petty cash book i found the “&minus” in all of my entries and i don’t know what it means.
Can you post screenshot where exactly you see this? I’m not sure in which context − does appear.
This happens when someone exports their bank account to TSV file. For some reason Excel see’s the dash as a minus.
− is an HTML entity name for the mathematical minus symbol which most people also use as a dash. If this is appearing in export, I’d guess that the Manager database either stores ‘-’ as − or replaces occurrences of it when parsing data for output in HTML (what is needed for the day-to-day use of the application). Perhaps the same parsing happens for export?
This is pure speculation on my part of course. I don’t know anything about the backend workings of the application. However, sorting out exported data in Excel should be a quick and simple matter of using Find and Replace to change all occurrences of − with a dash or minus character. Admittedly you’d need to do this for every export until the problem is resolved but at least you don’t need to change things on a line-by-line basis.
I fixed this in the latest version (15.3.3)
