Change the default Currency style

[Guest]

It is both frustrating an nonsenical that the default Currency style (ie the
one applied when you click the Currency button on the Formatting toolbar) is
actually based on an Accounting format.

Why isn't it based on a Currency format?
.... and why can't it be changed without creating a template? (ie so it
applies to all Workbooks rather than just newly created ones)

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-2bc47e67dd5c&dg=microsoft.public.excel.setup

 

[Nick Hodge]

BudgieBoy

You probably could find as many people who want it the other way.

You could take two routes.

1) In existing workbooks - To change all 'currency' formatted cells in one
go. Go to Format>Styles>Currency>Modify... change it to Currency and ok out
of dialogs. This will reset the 'currency style for this workbook and all
cells formatted as 'currency' will be changed immediately and future button
presses will format this way for this book

2) Re-purpose your currency button by inserting the below code in
personal.xls

Sub NewCurrencyFormat()
Selection.NumberFormat = "£#,##0.00;-£#,##0.00"
End Sub

and then right click on any toolbar, select 'customize'. With the dialog
showing, right-click on the currency button and select 'assign macro...' and
select this code. This will re-purpose the button for all future
applications of 'currency'

You could also have a button which sets the currency for existing sheets (as
1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)