recognizing the next cell and inserting the correct currency symbo
I have a cell say A1 with a drop down list of choosen currencies.eg. US $. In
the next cell say B1, I want it to insert the correct symbol depending on the
currency picked to be automatically inserted. In this case $. How can I do
this?
Hope this is clear.
Thanks Eqa.
|