Forum Discussion
blee6673
Mar 23, 2021Copper Contributor
Excel not calculating formulas in OneDrive
I have copy and pasted an excel document into one drive excel and the formulas are not working. I erased and re-enter the formula and am only getting a 0 value. Help, please. Is this a setting issue?...
SergeiBaklan
Mar 23, 2021Diamond Contributor
Could you please give sample of the formula which doesn't work?
- blee6673Mar 29, 2021Copper ContributorI figured it out. The Cell was changed from Currency to General, so the formula didn't know what to do with the $. Once I deleted and changed the cell back to currency, it worked. Thanks for reaching out.