May 7, 2006 #1 S strolch21 Newbie level 4 Joined Sep 1, 2005 Messages 5 Helped 0 Reputation 0 Reaction score 0 Trophy points 1,281 Activity points 1,308 excel ascii to integer Hi all, I am searching for an simple solution to convert a cell which shows ASCII Letters into an Integer. I know that there is an build in function. But what about converting an ASCII-HEX Value like "1AB0" into its integer value ?? Thanks for your help matthias
excel ascii to integer Hi all, I am searching for an simple solution to convert a cell which shows ASCII Letters into an Integer. I know that there is an build in function. But what about converting an ASCII-HEX Value like "1AB0" into its integer value ?? Thanks for your help matthias
May 9, 2006 #2 H Hughes Advanced Member level 3 Joined Jun 10, 2003 Messages 715 Helped 113 Reputation 226 Reaction score 26 Trophy points 1,298 Activity points 5,984 The built-in function is HEX2DEC.