Change the default $ setting to € on invoice template?

R

Ronan

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

Gord Dibben

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.

Tools>Protection>UnProtect Worksheet.

Select the cells to re-format and Format>Number>Accounting(or Currency).

Select the English Pounds and OK.

Save the template.


Gord Dibben MS Excel MVP
 
Top