Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average only cells that contain numbers April Excel Worksheet Functions 3 April 24th 23 09:07 AM
conditional formatting Lofty Excel Worksheet Functions 7 July 10th 06 09:06 PM
Sum multiple cells with different numbers and text. chrisjwhite24 Excel Discussion (Misc queries) 1 June 30th 06 05:03 PM
Excel auto formats cells with numbers - Can it be disabled? Jeromey Setting up and Configuration of Excel 1 May 21st 06 01:17 AM
Deferring conditional formatting? Pheasant Plucker® Excel Discussion (Misc queries) 14 March 17th 06 08:17 PM


All times are GMT +1. The time now is 07:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"