XL invoice replace the dollar sign with euro sign

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pamela casares - 16 Dec 2005 17:55 GMT

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

Reply to this Message

les8 - 16 Dec 2005 19:29 GMT

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

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

Reply to this Message

Gord Dibben - 16 Dec 2005 20:21 GMT

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

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

Reply to this Message