Or how it drops leading zeroes off of part numbers and no amount of custom formatting will convince it that something that starts 000#### should be displayed as is. Sure, we can pretend it’s text, but that’s annoying in its own way.
Other annoyances:
- formulas that don’t update results automatically even when they’re configured to do so
- the difficulty of creating a generic sheet to sheet reference in a calculation (“look up the value in a cell x on the worksheet three pages below this one”) I shouldn’t have to write a macro to do this.
