Oct, Oct$ Functions |
No
Oct(number)
number
Use: Required
Data Type: Numeric or String
Number or string representation of a number to convert.
A Variant of subtype String or a String
Returns the octal value of a given number.
If number isn't already a whole number, it's rounded to the nearest whole number before being evaluated.
If number is Null, Oct returns Null.
Oct returns up to 11 octal characters.
Oct returns a variant string, while Oct$ returns a string data type.
You can also use literals in your code to represent octal numbers by appending &O to the relevant octal value. For example, 100 decimal has the octal representation &O144. The following two statements each assign an octal value to a variable:
lngOctValue1 = &O200 ' Assigns 128 lngOctValue2 = "&O" & Len(dblNumber) ' Assigns 8