Excel value function

To remove leading zeros use value() function. Also lookup can be used with value function.