VALUE is your friend here. A good trick is to use hidden columns in case you need intermediate steps. Also, this helps if you want to take an iterative approach to your formulas (step by step using columns, then combining the steps into a long formula). Hope this helps.