Forum Discussion
MTGoblin
Mar 17, 2021Copper Contributor
AutoSum stopped working on Ipad
Hey y’all, I keep a tip log for work, and up until a couple weeks ago everything had been working great. Not sure what changed, but now when I try to auto sum it says something like “=SUM x111” t...
NikolinoDE
Mar 18, 2021Platinum Contributor
I am certainly not the most suitable person to help with the ipad.
But, since I spend some time here, I am also learning something :)).
The problem is probably in the TEXT format, then many arithmetic operations no longer work! Formatting after "number" must be done before the entry.
Mark the relevant area and choose "Text in columns" via "Data".
Then click on and finish several times without changing.
After that, it should be recognized as a real number.
Thanks for your time and patience
Nikolino
Ich weiß, dass ich nichts weiß (Sokrates)