Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 41
Default French formats for percentages

How does one re-format an EXCEL cell from the standard english format
("XX.X%") to the standard french format ("XX,X %")?

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 834
Default French formats for percentages

Change the language settings, Control Panel Regional and Language
OptionsRegional Options, press the Customize... button , change the Decimal
symbol.

--

HTH

Bob

"Eric_G" wrote in message
...
How does one re-format an EXCEL cell from the standard english format
("XX.X%") to the standard french format ("XX,X %")?

Thanks.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 41
Default French formats for percentages

thanks, but I believe this would change the settings for every spreadsheet on
my PC. I'm only looking to change the formatting for selected cells in
selected worksheets.

"Bob Phillips" wrote:

Change the language settings, Control Panel Regional and Language
OptionsRegional Options, press the Customize... button , change the Decimal
symbol.

--

HTH

Bob

"Eric_G" wrote in message
...
How does one re-format an EXCEL cell from the standard english format
("XX.X%") to the standard french format ("XX,X %")?

Thanks.



.

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
XL2007 French Numeric Formats LPS Excel Discussion (Misc queries) 1 April 30th 10 08:43 PM
French Character Sarang Excel Discussion (Misc queries) 1 February 1st 08 05:50 PM
French format Daniel Excel Discussion (Misc queries) 3 November 18th 07 04:25 PM
bad french characters George Campanis Excel Discussion (Misc queries) 0 July 11th 06 05:28 PM
French numeric formats Anthony LeBaron Excel Discussion (Misc queries) 3 January 7th 05 12:59 AM


All times are GMT +1. The time now is 11:44 AM.

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

About Us

"It's about Microsoft Excel"