Hello everyone,
is it possible to export in Excel, using a column as a formula?
Example:
When I export in Excel, Column “Total” is seen as a text column:
Is it possible to export it as a formula?
Hello everyone,
is it possible to export in Excel, using a column as a formula?
Example:
When I export in Excel, Column “Total” is seen as a text column:
Is it possible to export it as a formula?
As a workaround, if I export in Excel like the example before, I open the Excel file and replace “=” with “=” it recalculates everything fine.
You can try to do the replacing using a PowerShell script in EasyMorph. A quick googling returned a couple of helpful links:
https://www.zacoding.com/en/post/powershell-excel-replace-text/