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 » microsoft excel training - European Currency Formats
microsoft excel training - European Currency Formats
Resolved · Low Priority · Version Standard
Mon 30 Jul 2007, 10:30Delegate Debbie said...
Debbie has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Excel Pivot Tables course
European Currency Formats
We have been asked to submit a budget on an excel spreadsheet but the number format must use a comma in the decimal position and a decimal to indicate thousands. I thought I would be able to set this up using custom number formats but all I get is 3 decimal places in the UK format.
Does anyone have any suggestions
Wed 8 Aug 2007, 14:42Trainer Jacob said...
RE: European Currency Formats
Hi Debbie
If this still helps, the following should resolve your issue.
In Excel, goto Options, in the dialog box select the International tab.
You will now be able to specify the seperators the way you please.
Sorry for the delay!
Regards
Jacob
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:Shared Conditional FormattingIn a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones. |
