Oct, Oct$ Functions |
Named Arguments
No
Syntax
Oct(number)
number
Use: Required
Data Type: Numeric or String
Number or string representation of a number to convert.
Return Value
A Variant of subtype String or a String
Description
Returns the octal value of a given number.
Rules at a Glance
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.
If number is the special Empty variant, Oct returns (zero).
Oct returns up to 11 octal characters.
Oct returns a variant string, while Oct$ returns a string data type.
Programming Tips and Gotchas
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
See Also
- Hex, Hex$ Function
Get VB & VBA in a Nutshell: The Language now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.