Can I make a drop down list to choose formats not values?

Hi guys,

I'm making an excel sheet with two currencies ($ & €) in a certain column, so I want to apply a drop down list in this column's cells to choose the currency format after entering the amount. Is this possible?

Thanks,,

You can add drop down list in next cell that would hold both currencies.

hmmm,, nice idea .. Thank you