Excel formula translation corrupts sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2119515%22%20slang%3D%22en-US%22%3EExcel%20formula%20translation%20corrupts%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119515%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20experts%2C%20receiving%20an%20Excel%20from%20a%20foreign%20country%20leads%20to%20an%20unintended%20translation%20of%20the%20formula%20in%20a%20series%20of%20cells%2C%20which%20leads%20to%20lots%20of%20cells%20giving%20%23VALUE%20fault%20messages.%20What%20could%20solve%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Schermafbeelding%202021-02-09%20om%2021.38.04.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F253718iF96DDD3F3EC6CB57%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Schermafbeelding%202021-02-09%20om%2021.38.04.png%22%20alt%3D%22Schermafbeelding%202021-02-09%20om%2021.38.04.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2119515%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2119565%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20translation%20corrupts%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119565%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F961363%22%20target%3D%22_blank%22%3E%40PBeringer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20brackets%20%7B%20%7D%20around%20the%20formula%20in%20your%20screenshot%20indicate%20that%20it%20has%20been%20saved%20as%20an%20array%20formula.%20Try%20saving%20it%20as%20an%20ordinary%20formula%3A%3C%2FP%3E%0A%3CP%3E-%20Select%20the%20cell.%3C%2FP%3E%0A%3CP%3E-%20Press%20F2.%3C%2FP%3E%0A%3CP%3E-%20Press%20Enter%20without%20changing%20anything.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2126600%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20translation%20corrupts%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2126600%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F961363%22%20target%3D%22_blank%22%3E%40PBeringer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%23VALUE%20is%20Excel's%20way%20of%20saying%2C%20%22There's%20something%20wrong%20with%20the%20way%20your%20formula%20is%20typed.%20Or%2C%20there's%20something%20wrong%20with%20the%20cells%20you%20are%20referencing.%22%20The%20error%20is%20very%20general%2C%20and%20it%20can%20be%20hard%20to%20find%20the%20exact%20cause%20of%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERead%20this%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-correct-a-value-error-15e1b616-fbf2-4147-9c0b-0a11a20e409e%23%3A~%3Atext%3D%2523VALUE%2520is%2520Excel's%2520way%2520of%2Cthe%2520exact%2520cause%2520of%2520it.%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ereference%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Dear experts, receiving an Excel from a foreign country leads to an unintended translation of the formula in a series of cells, which leads to lots of cells giving #VALUE fault messages. What could solve this?

Schermafbeelding 2021-02-09 om 21.38.04.png

2 Replies

@PBeringer 

The brackets { } around the formula in your screenshot indicate that it has been saved as an array formula. Try saving it as an ordinary formula:

- Select the cell.

- Press F2.

- Press Enter without changing anything.

@PBeringer 

 

#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and it can be hard to find the exact cause of it.

 

Read this reference