XL invoice replace the dollar sign with euro sign

[Guest]

How do I replace the dollar sign with the euro sign trying to set up an XL
invoice?

 

[Guest]

After selecting the range, select Format, Cells, Currency and Symbol.

 

[Gord Dibben]

Pamela

Format>Cells>Number>Currency. Select the Euro sign.

Or................

Format>Style>Currency>Modify. Make the change here and all numbers will be
Euro-signed when formatted to Currency.

You can change Accounting format to Euros also.

This is workbook setting and is not global to all workbooks or new workbooks.

For all new workbooks use a new workbook Template with the settings you wish.


Gord Dibben Excel MVP

Then File>Save As>File Type
On Fri, 16 Dec 2005 09:55:02 -0800, "Pamela casares" <Pamela