Shop OBEX P1 Docs P2 Docs Learn Events
Displaying Binary or Hex values in Excel - SOLVED — Parallax Forums

Displaying Binary or Hex values in Excel - SOLVED

Beau SchwabeBeau Schwabe Posts: 6,570
edited 2009-11-01 02:34 in General Discussion
Does anyone know how to format a cell in Excel to display BINARY, HEX, or something other than DECIMAL without using a Macro? I thought for sure this would be a standard option, but I can't seem to find where to do it if there is such an option.

▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
Beau Schwabe

IC Layout Engineer
Parallax, Inc.

Post Edited (Beau Schwabe (Parallax)) : 10/31/2009 8:16:30 PM GMT

Comments

  • Beau SchwabeBeau Schwabe Posts: 6,570
    edited 2009-10-31 20:13
    Never mind ...

    Select Tools-->Add-Ins ... and check Analysis ToolPak


    And then use the labels below in each cell...

    =DEC2BIN: Convert decimal number to binary
    =DEC2OCT: Convert decimal numbers to octal
    =DEC2HEX: Convert decimal numbers to hexadecimal

    =BIN2DEC: Convert binary number to decimal
    =BIN2OCT: Convert binary numbers to octal
    =BIN2HEX: Convert binary numbers to hexadecimal

    =OCT2BIN: Convert octal numbers to binary
    =OCT2DEC: Convert octal number to decimal
    =OCT2HEX: Convert octal numbers to hexadecimal

    =HEX2DEC: Convert hexadecimal number to decimal
    =HEX2BIN: Convert hexadecimal numbers to binary
    =HEX2OCT: Convert hexadecimal numbers to octal

    ▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
    Beau Schwabe

    IC Layout Engineer
    Parallax, Inc.

    Post Edited (Beau Schwabe (Parallax)) : 10/31/2009 8:21:25 PM GMT
  • James LongJames Long Posts: 1,181
    edited 2009-10-31 21:27
    Beau Schwabe (Parallax) said...
    Never mind ...

    Select Tools-->Add-Ins ... and check Analysis ToolPak


    And then use the labels below in each cell...

    =DEC2BIN: Convert decimal number to binary
    =DEC2OCT: Convert decimal numbers to octal
    =DEC2HEX: Convert decimal numbers to hexadecimal

    =BIN2DEC: Convert binary number to decimal
    =BIN2OCT: Convert binary numbers to octal
    =BIN2HEX: Convert binary numbers to hexadecimal

    =OCT2BIN: Convert octal numbers to binary
    =OCT2DEC: Convert octal number to decimal
    =OCT2HEX: Convert octal numbers to hexadecimal

    =HEX2DEC: Convert hexadecimal number to decimal
    =HEX2BIN: Convert hexadecimal numbers to binary
    =HEX2OCT: Convert hexadecimal numbers to octal

    Wow....you ask a question, then answer it yourself......how fun is that for us??? smilewinkgrin.gif

    James L

    ▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
    James L
    Partner/Designer
    Lil Brother SMT Assembly Services

    Are you addicted to technology or Micro-controllers..... then checkout the forums at Savage Circuits. Learn to build your own Gizmos!
  • LeonLeon Posts: 7,620
    edited 2009-10-31 22:45
    Open Office Calc has the same functions.

    Leon

    ▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
    Amateur radio callsign: G1HSM
  • Beau SchwabeBeau Schwabe Posts: 6,570
    edited 2009-11-01 02:34
    James,

    lol! - I had been searching with no real luck, and then as soon as I post the question, I found what I was looking for.... Murphy's Law!

    BTW) The application is Propeller related for a future object, I just needed to stare at a bunch of "1"'s and "0"'s for awhile using Excel as a test bed.

    ▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
    Beau Schwabe

    IC Layout Engineer
    Parallax, Inc.

    Post Edited (Beau Schwabe (Parallax)) : 11/1/2009 2:40:44 AM GMT
Sign In or Register to comment.