Excel not calculating formulas in OneDrive

Copper Contributor

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 

Could you please give sample of the formula which doesn't work?

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.