Apr 11, 2012
Need to get this done: To have just ONE cell that is defined in a dropdown list with several (various) countries´┐Ż currencies, and each time when I choose a currency on this dropdown, EVERY cell in my worksheet which has a figure formatted with CURRENCY will automatically turn into that currency selected only in that dropdown cell. I have imagined whether if there was a solution, that the monetary cells do not necessarily have to be first in CURRENCY format, or do they have to? Anyway, I do nt know how to accomplish this, Without the solution, I have still at this time just set all the cells with monetary amounts in simple NUMBER format, ie. no CURRENCY SYMBOL at all, till I find a solution ..
View 1 Replies