How do I use base 256 numbers?

J

JonMartin

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

Excel does not accept text format! 0
Convert numerals 1
Numerals conversion 2
Format cells for hexadecimal numbers 2
Help! How do I ignore blanks cells in an array? 3
Conversion of Dec numbers to Bin, Oct and Hex and visa versa 1
Need help with how to convert IPnumbers to dotted quad 2
How to create a dynamic table based on a set of other nested attributes 0

Top