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

--
Alex St-Pierre