microsoft excel training - European Currency Formats

The UK's most regular instructor-led training courses.
Training information: microsoft excel training · Excel training london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

European Currency Formats

Debbie has attended:
Excel VBA course
Excel VBA course

by - delegate Debbie [3 posts] (2007 Jul 30 Mon, 10:30) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: European Currency Formats

by - trainer Jacob gold contributer [106 posts] (2007 Aug 8 Wed, 14:42) Reply

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

RE: European Currency Formats

by - delegate Debbie [3 posts] (2007 Aug 8 Wed, 15:00) Reply

Many thanks Jacob, I knew there had to be a way!

Debbie

· Microsoft Excel Features and Functions for Accountants
· Tap the Power of Recorded Macros with MS Excel Courses
· Compare Different MS Excel Training Methods
· Advanced level training: Microsoft Excel and the Web
· A Beginners Guide To Formulas In Excel

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips