Forum Discussion
Solved
Identical Excel formula work on one sheet but no another
Hi I am working on a spreadsheet from my colleague and I would like to use the & function or the CONCAT() function however it is not working on the spreadsheet they left me, however, when I have crea...
- It is fixed now, it is a setting problem, please check the solution here in case anyone needs it.
https://www.excelforum.com/excel-formulas-and-functions/1399559-identical-excel-formula-work-on-one-sheet-but-not-another.html#post5790107
Could it be that you have like an error in cell C9. What happens if you clear that cell, or enter a string?
- https://1drv.ms/x/s!ApRAKxWiqaZBhJ5VdLQZ9ltrEU85Hg?e=wMTZn8
The cell C9 is only a number, 1, not any type of calculation- I cannot access the file. Is it same result also if you change from C9 to another cell, eg an empty cell that you then enter 1 into?
Normally, it should be that the result in C9 cannot be treated as a string.
The result from the four tests?- It is fixed now, it is a setting problem, please check the solution here in case anyone needs it.
https://www.excelforum.com/excel-formulas-and-functions/1399559-identical-excel-formula-work-on-one-sheet-but-not-another.html#post5790107