I have a drop down box with two selections Orders and Sales. When orders
selected, I want just a number, when sales selected, I want currency format.

Using conditional formatting does not give the option to change number format.

Any ideas?

Thanks,
Tom