Different language formats
Tools-Options-International
"Anthony LeBaron" wrote:
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?
|