ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Change the default $ setting to ‚¬ on invoice template? (https://www.excelbanter.com/excel-discussion-misc-queries/109820-change-default-%24-setting-%E2%82%AC-invoice-template.html)

Ronan

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

Gord Dibben

Change the default $ setting to € on invoice template?
 
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




All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com