All that being said, I can't imagine what you could possibly be doing within Excel that would prevent you from having those numbers calculated by formula. When you reference another cell, Excel does its thing on the value, not the formula.

I think it would make more sense to keep the data as is and just add a new row with the inversed numbers as a formula.