United States (English) Sign in
Home Products Office 365 Docs Samples Downloads Training How To Support Forums
Office and SharePoint development > Office client development > Office 2010 > Office 2010 > Visual Basic for Applications Language Reference for Office 2010 > Visual Basic Language Reference > Functions > Oct Function
Office and SharePoint development
Office client development
Office 2010
Office 2010
Visual Basic for Applications Language Reference for Office 2010
Visual Basic Language Reference
Functions
Abs Function
Array Function
Asc Function
Atn Function
CallByName Function
Choose Function
Chr Function
Command Function
Conversion Functions
Cos Function
CreateObject Function
CurDir Function
CVErr Function
Date Function
DateAdd Function
DateDiff Function
DatePart Function
DateSerial Function
DateValue Function
Day Function
DDB Function
Derived Math Functions
Dir Function
DoEvents Function
Environ Function
EOF Function
Error Function
Exp Function
FileAttr Function
FileDateTime Function
FileLen Function
Filter Function
Format Function (Visual Basic for Applications)
FormatCurrency Function
FormatDateTime Function
FormatNumber Function
FormatPercent Function
FreeFile Function
FV Function
GetAllSettings Function
GetAttr Function
GetObject Function
GetSetting Function
Hex Function
Hour Function
IIf Function
IMEStatus Function
Input Function
InputBox Function
InStr Function
InStrRev Function
Int, Fix Functions
IPmt Function
IRR Function
IsArray Function
IsDate Function
IsEmpty Function
IsError Function
IsMissing Function
IsNull Function
IsNumeric Function
IsObject Function
Join Function
LBound Function
LCase Function
Left Function
Len Function
Loc Function
LOF Function
Log Function
LTrim, RTrim, and Trim Functions
MacID Function
MacScript Function
Math Functions
Mid Function
Minute Function
MIRR Function
Month Function
MonthName Function
MsgBox Function
Now Function
NPer Function
NPV Function
Oct Function
Partition Function
Pmt Function
PPmt Function
PV Function
QBColor Function
Rate Function
Replace Function
RGB Function
Right Function
Rnd Function
Round Function
Second Function
Seek Function
Sgn Function
Shell Function
Sin Function
SLN Function
Space Function
Spc Function
Split Function
Sqr Function
Str Function
StrComp Function
StrConv Function
String Function
StrReverse Function
Switch Function
SYD Function
Tab Function
Tan Function
Time Function
Timer Function
TimeSerial Function
TimeValue Function
Type Conversion Functions
TypeName Function
UBound Function
UCase Function
Val Function
VarType Function
Weekday Function
WeekdayName Function
Year Function
Expand Minimize
This topic has not yet been rated - Rate this topic

Oct Function

Office 2010
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Returns a Variant (String) representing the octal value of a number.

Syntax

Oct(number)

The required number argument is any valid numeric expression or string expression.

Remarks

If number is not already a whole number, it is rounded to the nearest whole number before being evaluated.

If number is

Oct returns

Null

Null

Empty

Zero (0)

Any other number

Up to 11 octal characters

You can represent octal numbers directly by preceding numbers in the proper range with &O . For example, . For example, &O10 is the octal notation for decimal 8.

This example uses the Oct function to return the octal value of a number.

Copy 
Dim MyOct
MyOct = Oct(4)     ' Returns 4.
MyOct = Oct(8)    ' Returns 10.
MyOct = Oct(459)    ' Returns 713.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.