Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert binary number to octal number

Status
Not open for further replies.

benzhaotb

Technical User
Dec 25, 2001
46
US
How do I convert binary to octal number with Excel? Thanks
 
The format is:

=BIN2OCT(1001, 3) (which equals 011)

If you cannot access BIN2OCT, then there is an additional step you need to take. You had to Add-In the Analysis Toolpak (TOOLS->ADD-INS, then check the ANALYSIS TOOLPAK box).

Thats it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top