Dynamic number formatting
Hi Stefano
You can't use Conditional Formatting to set the cells number format.
You could however, make the calculations that you carry out, all have
*$A$1 at the end of the calculation.
If you set A1 number format to be ? 1.00, then the results will display
in ?,
Change the format of cell A1 to £ 1.00 and the results will display in £
Sterling
--
Regards
Roger Govier
"smaruzzi" wrote in message
...
Costs in my sheet could be in a wide range of different currencies.
The ideal
visual outcome would be to associate the appropriate currency symbol
to each
cost number. The currency information is dynalically generate in a
cell
inside the working sheet. As an example, if Euro is the selected
currency,
all costs should look like this: ?123.00, ?435.65 and so on.
Is there a smart way to set a sort of conditional formatting so that -
based
on the currency selected at a given time - all financial figures are
represented with the appropriate currency symbol?
Thanks, Stefano
|