3 ms·
> Everyone has the same Excel setup. I wish this was true. The biggest problem is different language versions that cause all sorts of problems. Did you know th
by weinzierl 7y ago
> Everyone has the same Excel setup.
I wish this was true. The biggest problem is different language versions that cause all sorts of problems. Did you know that Excel formulae names are localized? For example AVERAGE is MITTELWERT if you have a German Excel and there are some with umlauts as well.
But there are more subtler problems. I'm an engineer and I used to work a lot with radians and degree values. There is this nice little trick in excel where you can enter radians and have it display as degrees. It works using the date format but only if you have 1900 dates enabled. I used to to use that for a short while until I noticed that all dates in spreadsheets from other people are off by 30 years.