ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting cells to display numbers in euro style (https://www.excelbanter.com/excel-discussion-misc-queries/110741-formatting-cells-display-numbers-euro-style.html)

Mary Fran

Formatting cells to display numbers in euro style
 
How can I format specific cells in Excel 2003 spreadsheets to display numbers
in French euro style (43,00 ‚¬ rather than 43.00 ‚¬). I have added the
currency conversion toolbar, but that still displays using a decimal point.

Since most of my calculations are in dollars, I don't want to make global
default changes.

Kentucky

Formatting cells to display numbers in euro style
 
Try selecting Regional and Language Options from the control panel and then
click the "customize" button. On the "Numbers" tab you can set the decimal
symbol to ",". This then should be affective in all Office applications.

Chris.

"Mary Fran" wrote:

How can I format specific cells in Excel 2003 spreadsheets to display numbers
in French euro style (43,00 ‚¬ rather than 43.00 ‚¬). I have added the
currency conversion toolbar, but that still displays using a decimal point.

Since most of my calculations are in dollars, I don't want to make global
default changes.



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

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