Write Excel - How to write an integer as an integer but keep a zero

RMBPRMBP MemberPosts:4Contributor I
edited December 2018 inHelp

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?

使用“#”数字格式: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!

Tagged:

Best Answer

  • FBTFBT MemberPosts:106Unicorn
    Solution Accepted

    Try using number format: "0" (without quotation marks).

    Telcontar120 sgenzer
    Sign InorRegisterto comment.