Hi.

Is it possible to set the Decimal Places programmatically using VB?
I'm using oWrkSheet.Cells(110, 17).NumberFormat = "0.00%" but am wondering if there is a Property for this?
(I was thinking ...DecimalPlaces = 2). I did a search for it but could not find anything.

Thanks.

Rita

That is the correct way to do it.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.

Ok. Thanks.