Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DYnamic currency symbol
My XLS contains different currencies (i.e. $, £, ‚¬, ...), one per sheet. Is
there a smart way to use the same formulas and formatting forcing the dynamic adoption of the appropriate currency symbol, an information known in each worksheet? As an example, when dealing with British Pounds, all financial data should be preceded by £. Automatically a different sheet populated with US $ will prefix financial figures by $. Thanks, Stefano |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add new currency symbol | Excel Discussion (Misc queries) | |||
Formatting with currency symbol | Excel Discussion (Misc queries) | |||
How to add currency symbol to a cell value | Excel Discussion (Misc queries) | |||
How do I add a currency symbol | Excel Discussion (Misc queries) | |||
Currency Symbol | Setting up and Configuration of Excel |