turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community Home
- :
- Product Help
- :
- RapidMiner Studio Forum
- :
- Write Excel - How to write an integer as an intege...

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

2 weeks ago

2 weeks ago
2 weeks ago

2 weeks ago
Using the Write Excel, how do I number format so 1 will stay 1, but 0 will stay 0, and Excel will read the column as a number?

Using number format: '#' I get integers, but zeroes appear as blanks.

If I put a Number Format operator before Write Excel, I get 1 and 0, but Excel itself thinks this column is text.

Thanks!

Solved! Go to Solution.

1 REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

2 weeks ago

2 weeks ago