Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - European Currency Formats
|
|
|
The UK's most regular 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. |
microsoft excel training - European Currency Formats
Resolved · Low Priority · Version Standard
Reply Mon 30 Jul 2007, 10:30Delegate Debbie said...
Debbie has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate 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
For upcoming training course dates see: Pricing & availability
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
Reply Wed 8 Aug 2007, 15:00Delegate Debbie said...
RE: European Currency Formats
Many thanks Jacob, I knew there had to be a way!
Debbie
|