Forum Discussion
PBeringer
Feb 09, 2021Copper Contributor
Excel formula translation corrupts sheet
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 s...
HansVogelaar
Feb 09, 2021MVP
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.