How to let excel convert between metric and imperial units when I input any of them in a table?

Update: I am trying to enter length width and height size in ft and want it to convert immediately to metric and vise versa when I input in the cell for metric it automatically changes the second cell in imperial.
3 answers 3