Thread: Max Hex characters set to ten?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
derrick.burns@l derrick.burns@l is offline
external usenet poster
  
Posts: 1
Default Max Hex characters set to ten?

I need to track MAC address, which are hex based.
to be able to create a reliable "fill down" I created the following
formual.

=dec2hex(hex2dec(A2)+2)

Takes the hex data from the above cell (A1), converts to decimal adds 2
then converts back to hex. but only works for 10 characters.

My problem is that the MAC adress is 12 characters long.
=dec2hex(hex2dec(C6)+2, 12)
responds with the "#NUM" error.


Is there a way to adjust character limit?


--
derrick.burns@l
------------------------------------------------------------------------
derrick.burns@l's Profile: http://www.excelforum.com/member.php...o&userid=36855
View this thread: http://www.excelforum.com/showthread...hreadid=565721

Reply With QuoteReply With Quote