LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anthony LeBaron
 
Posts: n/a
Default Different language formats

I need to create excel spreadsheets using both english and french language
formats.
I believe I can accomplish different language formats by doing a global
change to my operating system, but I don't want to do this.

I have been able to change simple numbers by using custom masks i.e.
###,###,##0 becomes ### ### ##0

But I am unable to change the english decimal point to the french comma, as
the comma is automatically considered to be a thousands seperator.

##0,0 %;(##0,0) % will not work. And there is no locale option for
percentage.

Any ideas?


 
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
Eliminating default language settings to all Office 2003 apps. Schermie Excel Discussion (Misc queries) 0 May 6th 06 07:49 PM
language support in excel sheet using a third party language tool seema Excel Worksheet Functions 0 March 13th 06 06:06 AM
OS language and Office language conflicts teejay Excel Worksheet Functions 1 February 10th 06 05:31 PM
How do I find out how many different cell formats an existing wor. wheelsii Excel Discussion (Misc queries) 1 March 24th 05 04:58 PM
How to change the excel format from language to language? zee Excel Discussion (Misc queries) 2 January 30th 05 06:51 PM


All times are GMT +1. The time now is 03:11 PM.

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"