Help! How can I change Pound to Euro?

Change the pound sign to euro sign in your reports by using the PPOL Word Macros in three easy steps.

• Download the macros file
• Install the macros in Word
• Run the macro for a report

And you only need to do the first two steps once for your computer. The macro is then available to change the pound sign to euro sign in each of your reports.

What is a macro? A macro is a saved set of Word instructions. When a particular task needs to be repeated on many occasions the steps can be recorded as a macro so that they then can be re-used in the future.

Here are the full instructions:

Download the macros file

• Click on the download button next to PPOL Word macros at the bottom of this page
• Save the file PPOL_Pound2Euro.BAS to your computer (take a note of where it is saved)

Install the macros in Word

• Fire up Word
• Press ALT & F11 to open the Visual Basic for Applications (VBA) window
• In the Project pane (find it on the left hand side) click on Normal
• From the menu select File then Import File
• Click on Browse and navigate to where you saved the file.
• Select PPOL_Pound2Euro.BAS
• Click Open
• Close the VBA window

Run the macro for a report (for newer Word versions)

These are the instructions for newer versions of Word that use the ribbon interface (see below for older versions that use menus).

• Open the report in Word
• Select the View tab
• Click on the Macros button (on the right hand end of the ribbon - if the dropdown menu appears select View Macros)
• Select Pound2Euro
• Click Run to change the pound sign to euro sign
• Save the report in the normal way

Run the macro for a report (for older Word versions)

These are the instructions for older versions of Word that use menus.

• Open the report in Word
• Select menu options Tools then Macro then Macros
• Select Pound2Euro
• Click Run to add Page Numbers and Table of Contents
• Save the report in the normal way

Keyboard Shortcut

Optionally create a keyboard shortcut to run the macro here