Ed Saltelli | 2007-11-02 10:16:58.0 | |
I currently have a spreadsheet that contains numbers that have a formatting applied to be represented as integers. However at run-time values for this column always comes back as a Double. What mechanisms are there that I can expect to get my data back as an Integer instead of a Double? Thanks! Ed | ||
HXTT Support | 2007-11-02 17:44:25.0 | |
>I currently have a spreadsheet that contains numbers that have a
> formatting applied to be represented as integers. You can zip and send us a sample so that we can check whether it's possible for HXTT Excel to detect automatically it as int. >What mechanisms are there that I can expect to get my data back as an > Integer instead of a Double? For instance, INT(x) : truncates x to nearest integer at Scalar Functions and Aggregate Functions. |