Re: Dynamic number formatting

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <smaruzzi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:763A4498-DC91-461E-9F5E-33CD80419ECD@xxxxxxxxxxxxxxxx
Costs in my *** 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 ***. 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


.

Quantcast