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?
- shelbsassyDec 15, 2021Copper ContributorUnfortunately, no it did not. I am able to use formulas on Office365 via a browser, so I can just stick with that. Thanks