From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

Conversion of values into binary, octal, decimal, and hexadecimal equivalents

Conversion of values into binary, octal, decimal, and hexadecimal equivalents - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Conversion of values into binary, octal, decimal, and hexadecimal equivalents

“

- [Dennis] On this worksheet in column A, 2 we see 12 different functions, 3 and they have an unusual look to them. 4 They all have the number 2 as the middle character. 5 Think of the number 2 in each of these 6 as meaning the word T-O. 7 BIN2OCT really means this is the function 8 that will convert binary numbers to octal numbers. 9 Next one, binary to decimal, and so on. 10 12 of these right here. 11 We also see them depicted in the shadow box 12 to the right in a slightly different way. 13 And these are the kind of functions 14 that most Excel business users don't need. 15 But if you're in the scientific environment, rephrase, 16 but if you're in a scientific or engineering environment, 17 or if you're a computer science major, 18 these can be extremely important. 19 If you were trying to track these down 20 in the ribbon menu system under Formulas, 21 you won't see it under Math & Trig. 22 That might be the first…

Contents