Using Excel 2003:

What I would like to do is type a number into a cell and then when I hit
enter I would like vba to update that number through a formula. I know I
could just add another column but if possible I would like to do it the way
mentioned.

Pete Provencher