Format function with international numbers

[Guest]

Hi,
I have an excel program which generate a word report in french or english.
The program request that the regional settings must be set to the language of
the report English (Canada) or French (Canada). I would like to avoid the
modification of the regional settings. I tried the following:
Sub Macro1()
Dim sValue as String
sValue = Format(2500000, "#,##0")
End Sub
This always gives 2 500 000 when the regional setting is French(Canada). I'm
wondering if there's a way to modify the format function to show 2,500,000
when the report is created in english ?
Thanks!
Alex

 

[Guest]

I have not tried it, but I would guess that if the international setting is
English, you could use default to get 2,500,000.

 

[Tom Ogilvy]

Stephen Bullen has the chapter of his book that deals with international
issues available on his web site. Take a look:

http://www.oaltd.co.uk/ExcelProgRef/ch22/