Igor,

I think the FIX setting is the only one accessible via VBA.

Application.FixedDecimal = True
Application.FixedDecimalPlaces = 2

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Igor" wrote in message
...
Thank you, but how do you access these options in excel
and in VBA

thank you
Igor