With the freeware Version up to 100.000 recordscan be processed!

Download Freeware Version !!! no registration required !!!

See also the existing examples of using the Excel Adapter , which may answer your question: CSV export with grouping

Format Excel number without decimals

FlowHeater-Team
Topic Author
Offline
Administrator

More

9 years 11 months ago #2261 by FlowHeater-Team

Format Excel number without decimals was created by FlowHeater-Team

Hello,

could you please tell me why when I open an excel document in flowheater in the ID section it shows a number with two decimals after each item number. In the excel spreadsheet I changed item ID to GENERAL category instead of number, but it didn't help.

Thank you,
Elena

Support request received via email

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

FlowHeater-Team
Topic Author
Offline
Administrator

More

9 years 11 months ago #2262 by FlowHeater-Team

Replied by FlowHeater-Team on topic Re:Format Excel number without decimals

hi elena,

flowheater detect numbers in excel sheets always as flowheater data type decimal or double. in case you would like to export these values without decimals you just have to switch the flowheater data type manually to the flowheater data type integer. that’s all.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Attachments: