Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average only cells that contain numbers | Excel Worksheet Functions | |||
conditional formatting | Excel Worksheet Functions | |||
Sum multiple cells with different numbers and text. | Excel Discussion (Misc queries) | |||
Excel auto formats cells with numbers - Can it be disabled? | Setting up and Configuration of Excel | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) |