Forum Discussion

blee6673's avatar
blee6673
Copper Contributor
Mar 23, 2021

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?

2 Replies

    • blee6673's avatar
      blee6673
      Copper Contributor
      I 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.

Resources