Hi everyone,
When I output Excel formulas using a regular Output tool, Excel was able to read and convert the formulas into values. However, when using the Render tool to output to a rendered Excel, Excel was not able to convert the formulas into values and show the formulas as text (please see screenshot below) until I double click on the cell and press Enter.
Is there anyway for Excel to recognize and convert the formulas to values when output using the Render tool? I hope am just missing something.
Appreciate any help given. Thanks!