Open the folder that the Invoice.xlt template is stored in.

Right-click on the file and "Open".....DO NOT double-click to open.

The Template(*.xlt) will open.

ToolsProtectionUnProtect Worksheet.

Select the cells to re-format and FormatNumberAccounting(or Currency).

Select the English Pounds and OK.

Save the template.


Gord Dibben MS Excel MVP

On Wed, 13 Sep 2006 14:09:02 -0700, Ronan
wrote:

How can I change the default $ setting to € on invoice template?
My local setting is set for European location