I am trying to use the datatable format to put numbers and formula into a csv file. However, when we export the datatable to the CSV, the formulas stay there as text. The only way to activate them is to use the Enter key.

For instance, when inputting SUM, the Excel won’t show a sum of two numbers, instead it would show “=SUM(A1:A2)”

How can I make the Excel formulas active when putting them in Excel?