Please how can I automatically format the following. Where the following
amount are entered in a cell it should change to respective Currency format.
if I enter 1.000 it should automatically change to USD.

1.000 = USD
0.893 = CAD
1.975 = GBP
1.3440 = EUR
0.754 = CHK

All help totally appreciated.Thanks for your assistance