Forum Discussion
shelbsassy
Dec 15, 2021Copper Contributor
Excel not recognizing formulas
This has been happening for a while. I am unable to use formulas in Excel. I have the fields set to GENERAL and I am trying to get the first 5 of a zip code using =LEFT(A1,5) but I get an error any...
SergeiBaklan
Dec 15, 2021Diamond Contributor
Perhaps you shall use semicolon instead of comma. If you open attached file does formula work?
shelbsassy
Dec 15, 2021Copper Contributor
Unfortunately, no it did not. I am able to use formulas on Office365 via a browser, so I can just stick with that. Thanks