microsoft excel training - european currency formats

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

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

microsoft excel training - European Currency Formats

resolvedResolved · Low Priority · Version 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:

Shared Conditional Formatting

In 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.

View all Excel hints and tips


Server loaded in 0.08 secs.