ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   XL invoice replace the dollar sign with euro sign (https://www.excelbanter.com/new-users-excel/60790-xl-invoice-replace-dollar-sign-euro-sign.html)

Pamela casares

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

les8

XL invoice replace the dollar sign with euro sign
 
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?


Gord Dibben

XL invoice replace the dollar sign with euro sign
 
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?



All times are GMT +1. The time now is 02:59 PM.

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