Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Format Excel number without decimals

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
11 years 2 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 to join the conversation.

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
11 years 2 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:

Please Log in to join the conversation.

Time to create page: 0.285 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.