Format Excel number without decimals
- FlowHeater-Team
- Topic Author
- Offline
- Admin
Less
More
11 years 10 months ago #2261
by FlowHeater-Team
Best wishes
Robert Stark
Format Excel number without decimals - Post(2261) 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
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
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Topic Author
- Offline
- Admin
11 years 10 months ago #2262
by FlowHeater-Team
Best wishes
Robert Stark
Replied by FlowHeater-Team on topic Re:Format Excel number without decimals - Post(2262)
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.
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
Attachments:
Please Log in or Create an account to join the conversation.
Time to create page: 0.261 seconds