Default Currency

=?Utf-8?B?U3R1YXJ0?=

Guest

Posts: n/a

10th Mar 2005

Although my Regional Currency is set to English £, Excel doesn't appear to be
able to 'see' it, so when I click on the currency button all I get is '$'.
Changing 'Style' in 'Format' only produces '£' for that particular worksheet
at the time, open up another worksheet and your back to square one.
How can I 'default' the currency to '£'?
--
StuartFM

« Pasting CSV list into separate cells... | In Excel, how do I get rid of duplicate records? Based on text r. »

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
how do I sum currency values in a row containing currency and uni.	Eusebius	Microsoft Excel Worksheet Functions	2	13th Nov 2008 02:35 PM
Excel's financial currency format vs. Access currency format	RoBo	Microsoft Access Forms	0	4th Feb 2008 05:03 PM
Currency Datatype Really Good to Use For Non-currency Fields?	tbl	Microsoft Access Database Table Design	4	10th Jul 2006 02:58 PM
Currency or Double for currency values	Tim Zych	Microsoft Access Database Table Design	8	10th Nov 2004 11:07 AM
Conversion from currency value to currency text format	gdselva	Microsoft Excel Programming	2	18th Aug 2004 10:06 PM