DYnamic currency symbol

smaruzzi

Guest

Posts: n/a

16th Jun 2008

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

« RE:More than 65,000 records for Excel 2007 problems! | How do i set up blink a perticular cell? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Currency Symbol	Jefferson Yesupatham	Microsoft Excel Misc	2	23rd Apr 2010 12:31 PM
How to add new currency Symbol in Format/Cell/Currency	NOORZAD	Microsoft Excel Misc	2	22nd Jun 2009 07:59 AM
How do I add a currency symbol	=?Utf-8?B?R2FicmllbGE=?=	Microsoft Excel Misc	2	20th Aug 2007 09:14 PM
Currency Symbol	Deon	Microsoft Excel Setup	1	6th Apr 2005 10:53 PM
Yen currency symbol	Andrew McDermott	Microsoft Excel Misc	1	17th Nov 2003 10:16 PM