Excel not calculating formulas in OneDrive

%3CLINGO-SUB%20id%3D%22lingo-sub-2230460%22%20slang%3D%22en-US%22%3EExcel%20not%20calculating%20formulas%20in%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2230460%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20copy%20and%20pasted%20an%20excel%20document%20into%20one%20drive%20excel%20and%20the%20formulas%20are%20not%20working.%20I%20erased%20and%20re-enter%20the%20formula%20and%20am%20only%20getting%20a%200%20value.%20Help%2C%20please.%20Is%20this%20a%20setting%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2230460%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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.