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

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

"Pamela casares" wrote:

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

Pamela

FormatCellsNumberCurrency. Select the Euro sign.

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

FormatStyleCurrencyModify. 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 FileSave AsFile Type
On Fri, 16 Dec 2005 09:55:02 -0800, "Pamela casares" <Pamela
wrote:

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