What I would like to do is type in a numeric value in one currency and have
it automatically convert to another currency in the same cell I enter it.

I know this is simple when you enter the original value in one cell and then
convert it with a formula in another cell, but I wish to have converted value
displayed in the same cell the original value is entered.

Any suggestions are appreciated.