ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i get euros instead of dollars from currency icon (https://www.excelbanter.com/excel-discussion-misc-queries/243827-how-do-i-get-euros-instead-dollars-currency-icon.html)

seamusrflynn

how do i get euros instead of dollars from currency icon
 
i seem to have lost the euro value and all i have is dollars

Gord Dibben

how do i get euros instead of dollars from currency icon
 
To make Euros the default for all workbooks change the Currency setting in
Control PanelRegional and Language Settings.

For a single workbook modify the Currency under FormatStyleCurrency.


Gord Dibben MS Excel MVP

On Sat, 26 Sep 2009 05:46:01 -0700, seamusrflynn
wrote:

i seem to have lost the euro value and all i have is dollars



trip_to_tokyo[_2_]

how do i get euros instead of dollars from currency icon
 
In EXCEL 2007:-

Home / Font / single left hand click on arrow in lower right hand corner /
Format Cells should launch / Number tab / Currency / single left hand click
on downwards facing arrow in Symbol: field / there are numerous currencies in
here to choose from.

Please hit Yes if my comments have helped.

Thanks.



"seamusrflynn" wrote:

i seem to have lost the euro value and all i have is dollars



All times are GMT +1. The time now is 08:29 PM.

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