Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel training - european currency formats

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - European Currency Formats

microsoft excel training - European Currency Formats

ResolvedVersion Standard

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

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

RE: European Currency Formats

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

Debbie

Excel tip:

Some examples of CTRL key shortcuts in Excel 2010

Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version?

They remain exactly the same:

Ctrl+B for bold
Ctrl+I for italics
Ctrl+P to Print
Ctrl+S to Save

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.