Convert octal to decimal

K

Ken

Is there a standard function that converts an octal number
to the corresponding decimal number?

Like the "inverse Oct()"
 
W

Wayne Morgan

?Oct(8)
10
?CInt(&O10)
8
?&O10
8

The &O (letter O) will designate a number as Octal. From the third example
(from the Immediate window) it appears that VBA will use the number directly
if formatted correctly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert decimal to octal numbers 1
Converting Numbers with Visual Basic 1
Convert numerals 11
Numerals conversion 2
Octal number to int number 5
Conversions using User Defined Functions 1
how to go from decimal to Octal numbers in c# 1
queries on "SET /A" to evaluate numerical expression 4

Top