表单字段作为文本导出到Excel [英] Form field exports to Excel as text

问题描述

表格字段"Gross"是表中的数字字段，表示将表单导出到Excel时。没问题。

Form field "Gross" is a number field from the table, and represents as such when the form is exported to Excel. No problem.

问题---表格字段"净"是根据字段"Gross"计算的字段。 x表单中的％。 将表单导出到Excel时，此字段表示为文本，如果不将每个记录"x 1"相乘，则无法求和。   需要此
字段才能在Excel中显示为数字。

Problem --- Form field "Net" is a field calculated from field "Gross" x a % in the form.  When the form is exported to Excel, this field represents as text, and cannot be summed without multiplying every record "x 1".    Need this field to show up in Excel as a number.

任何帮助都将非常感谢。

Any assistance will be greatly appreciated.

  - Mik

 - Mik

推荐答案

你碰巧没有在它上面设置格式，是吗？如果是这样，请尝试将其取下。

You don't happen to be setting a Format on it, are you? If so, try taking it off.

这篇关于表单字段作为文本导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！