Strange #VALUE! Error

%3CLINGO-SUB%20id%3D%22lingo-sub-1492026%22%20slang%3D%22en-US%22%3EStrange%20%23VALUE!%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492026%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20some%20reason%20the%20left%20and%20right%20formulas%20are%20not%20working%20on%20a%20specific%20sheet%20in%20my%20workbook%2C%20and%20only%20on%20numbers.%20They%20work%20fine%20on%20text%2C%20and%20they%20work%20fine%20on%20numbers%20in%20the%20other%20sheets.%20I've%20been%20going%20through%20all%20the%20settings%20trying%20to%20see%20if%20there%20are%20any%20%22Sheet%20Specific%22%20options%2C%20but%20so%20far%20no%20luck.%20Both%20the%20value%20cell%20and%20the%20formula%20cell%20or%20formatted%20as%20General.%20I%20saved%20the%20sheet%20as%20it's%20own%20file%2C%20deleted%20all%20my%20data%2C%20and%20the%20formula%20still%20doesn't%20work.%20I've%20attached%20that%20to%20see%20if%20anyone%20can%20figure%20out%20any%20solution.%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Almostnotfamous_0-1593177360875.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201302iB5A4ED99FDFFAC48%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Almostnotfamous_0-1593177360875.png%22%20alt%3D%22Almostnotfamous_0-1593177360875.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1492026%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

For some reason the left and right formulas are not working on a specific sheet in my workbook, and only on numbers. They work fine on text, and they work fine on numbers in the other sheets. I've been going through all the settings trying to see if there are any "Sheet Specific" options, but so far no luck. Both the value cell and the formula cell or formatted as General. I saved the sheet as it's own file, deleted all my data, and the formula still doesn't work. I've attached that to see if anyone can figure out any solution. Thanks!

 

Almostnotfamous_0-1593177360875.png

 

3 Replies
Highlighted

@Almostnotfamous 

If uncheck this setting

image.png

formula works.

Highlighted

That worked! You know i saw that mentioned somewhere, and i just couldn't find it in the options anywhere. I thought it'd be more in the sections related to formulas. Thank you!@Sergei Baklan 

Highlighted

@Almostnotfamous , you are welcome.

Formulas section settings affects entire application. If you see difference between worksheets check settings in Advanced.