| | | In Excel 2007 (and later) this function has been removed from the Analysis ToolPak add-in and is available as standard. |
| | | In Excel 2003 this function is only available when you have the Analysis ToolPak add-in loaded. |
| | | If any of the arguments are not numeric, then #VALUE! is returned. |
| | | If "number" < -536,870,912, then #NUM! is returned. |
| | | If "number" > 536,870,911, then #NUM! is returned. |
| | | If "number" < 0, then "places" is ignored and a 10-character (30-bit) octal number is returned. The first bit is the sign. |
| | | If "number" < 0, then two's-complement notation is used to represent the number. |
| | | If "places" is not an integer, it is truncated. |
| | | If "places" < 0, then #NUM! is returned. |
| | | If "places" is left blank, then the minimum number of characters necessary. |
| | | The "places" is useful for padding the return value with leading 0s. |
| | | If "places" is less than the number of characters, then #NUM! is returned. |
