Hello !
I need to update a spreadsheet in order to calculate expenses.
I’ve created a zap using “Add Row to Excel”. Everything works fine, but the numeric data is pasted as text in Excel and therefore not calculated unless I manually “touch” (double-click) the cell.
I’ve tried to add a “Format” zap to change the input data (currency) into number.
I’ve tried to update the cell with the formula: value(“xx,xx”) where xx,xx is the amount in currency that I need to update.
Is there any way to paste numeric data in excel so that it’s automatically calcultated by the destination spreadhseet ?
Thanks in advance for your input and insights in the issue.
