Summary

When the Insert Data activity inserts a number into a Number column in a Microsoft Excel file, the number value is stored as text. This causes certain Excel functions (e.g., SUM) to ignore the values inserted into the cells by Workflow.

Cause

This is a limitation of the Excel database engine and ODBC driver. The driver always converts values to text.

Workaround 1

Instead of directly running Excel functions on the inserted value, make use of another Excel function (i.e., VALUE) to copy the inserted value into a second column as a number and process the copied value.

Related Links

https://answers.laserfiche.com/questions/55687/Insert-Data-to-Excel-Error-Number-stored-as-text