How do I use base 256 numbers?

G

Guest

Excel knows how to use nubers in verious bases like Binary (Base 2) Octal
(Base 8) Hex (Base 16) and of cource decimal (base 10) so why not IP (base
256)

Why can't I just tell excel that the numbers are in base 256 format and then
be able to sort, add, xor etc?
 
D

David Biddulph

JonMartin said:
Excel knows how to use nubers in verious bases like Binary (Base 2) Octal
(Base 8) Hex (Base 16) and of cource decimal (base 10) so why not IP (base
256)

Why can't I just tell excel that the numbers are in base 256 format and
then
be able to sort, add, xor etc?
Click to expand...

With hex we use 0 to 9 and A to E. What are you going to use for the extra
240 different characters?
 

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 numerals 11
Numerals conversion 2
Conversion of Dec numbers to Bin, Oct and Hex and visa versa 1
XL2000 - How do i change number base? 1
How do I change the sign of a base number for use in XIRR? 1
Convert decimal to octal numbers 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Excel 2007 named ranges - how to use as function parameter? 3

Top