![]() ![]() If the argument is a date, number of days since (serial date) is used as numeric value of the expression. If the argument is an error, the error number is used as numeric value of the expression. when after trimming leading whitespace it doesn't start with plus, minus, a decimal digit, or "&", or when the sequence after "&O" is longer than 11 characters or contains an alphabetic character, the numeric value of expression is 0. Hexadecimal numbers like "&Hnnn.", where "nnn." after "&H" or "&h" is sequence of characters up to the next non-alphanumeric character, and must be no longer than 8 digits, from 0 to 9, A to F, or a to f. Octal numbers like "&Onnn.", where "nnn." after "&O" or "&o" is sequence no longer than 11 digits, from 0 to 7, up to the next non-alphanumeric character The syntax below are recognized:ĭecimal numbers (with optional leading sign) using decimal and group separators of locale configured in Collabora Office (group separators are accepted in any position), with optional exponential notation like "-12e+1" (where an optionally signed whole decimal number after e or E or d or D defines power of 10) If the argument is string, the function trims the leading white space then it tries to recognize a number in following characters. If the argument is a number, it is used as numeric value of the expression. Expression: Any expression that you want to convert.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |