6 ms·
Regarding Excel: Watch out with multi language setups! I was working with an English iPhone, an English Windows PC and a Swiss German Mac on an Excel file stor
by m_st 5y ago
Regarding Excel: Watch out with multi language setups!
I was working with an English iPhone, an English Windows PC and a Swiss German Mac on an Excel file stored on One Drive. Editing sometimes in Excel and sometimes in Excel Online.
Result: Broken data due to SUM/SUMME/etc formulas, broken phone number recognition and (worst) broken dates.
What a mess!
- ProblemFactory 5y agoAnd broken CSV files. In some European locales Excel switches from importing/exporting Comma Separated Values to Semicolon Separated Values with comma acting as the decimal point.
- mobilio 5y agoI'm also victim of this. It can be fix if you do import from file and then manually select separator. But this was need to be done every. single. time.