tk-wf
4 years agoNew Contributor
EXCEL Formatter: Is it possible to write formulas to cells?
We are trying to write formula strings as values to Excel cells, but when the file is opened all that appears are the formula strings and not the evaluated values.
We have tried prepending an ‘=’ to the strings but that just results in the string with an ‘=’ char prepended. Hitting ‘F2’ in a cell will immediately evaluate the cell, but that is not workable for end users.
If we modify the cell in-place with the ‘=’ character then the formula evaluates.
Any help/guidance is appreciated.
Thanks,
TK