98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Default currency settings?
Default currency settings?
Resolved · Low Priority · Version 2007
Mon 15 Apr 2013, 16:10Delegate Neil said...
Neil has attended:
Excel Advanced course
Default currency settings?
In some established workbooks some data converts into Euros. This has been both previously formatted and unformatted data. When inserting a new worksheet this automatically is formatted as euros. I don't necessarily want to reformat an established worksheet as this will include both dates and values.
Is there a way to stop this from happening?
Tue 16 Apr 2013, 11:14Trainer Gary said...
RE: Default currency settings?
Hi
Thanks for getting in touch. This setting is controlled from two places.
First set the cell style: this is done from the Home tab > Cell Styles > right-click Normal > Modify > Format and set the formatting as required.
This may also be controlled at a Windows level. This will be governed by regional settings and in my experience is locked down by IT. If you have access to Control Panel however you can change the region settings to your locale.
Give it a try and let me know how you get on.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Wed 17 Apr 2013, 08:44Delegate Neil said...
RE: Default currency settings?
Hi,
Thanks for getting back to me. I've checked the control panel and this is set to £.
The issue does not crop up in new spreadsheets, and not all spreadsheets. There are a lot of macros working from a couple of programmes used to extract data / reports from Oracle. Conceivably could this interfere with the currency?
Wed 17 Apr 2013, 09:23Trainer Gary said...
RE: Default currency settings?
Hi Neil
Thanks for your reply. It is possible that the macro includes or pulls across some formatting from the Oracle database.
If that's the case it's probably easier for someone who can edit macros to force £ formatting on to the sheet.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Tue 23 Apr 2013: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Find cells that match a formatIn Excel you may wish to find cells that contain a specific formatting such s colour. |
