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?