I have Two Worksheets in a Workbook (attached) that change Currency Formatting when a new Currency is selected. A table controls the decimal points on the results. I have some fields that require 2 Decimals and some that require -0- (i.e. numbers ranging from .15 to 150000000. So you see the need for controlling the decimal points at the end result cell.
I'm hoping there is a simple way to do this but I have tried changing the Cell Formatting (which reverts to the table when the currency changes). Any ideas?