Hi,

Could anybody help me ?

I have a trouble with starting excel and the local parameters...

I have made a .xls file with a SAS programm. This .xls file contain numeric
fields, text fields, ... and number with decimal point.
The decimal separator is the point(".").

I'm in France, so my local parameters tells excel that the decimal separator
is the comma (",").

When I double-click on the .xls file, the result is good : all the numéric
field with decimals are change from xxx.xx th xxx,xx

But when I start excel from my application SAS and I give the file to open
(.xls), the result is that the decimal fields are not convertef
form xxx.xx to xxx,xx

You can show it if you create a .txt file with NotePad : write 12.23 in the
..txt file, then renamed it in windows in .xls file.
If you double-click on this .xls file, the result is ok : 12.23 converted
into 12,23
But if you start excel and open the .xls file, after the formatting screens,
the result is not ok : the 12.23 is not converted
into 12,23 ....

I'm in excel 2000.

I can't use VBA script or macros because I start excel from SAS.

I'm searching a trick to start excel and tell him he have to take care of
local parameters (and transforming the "." decimal into "," decimal.

Thanks you very much for your help.

Pascal