Hi The 2 questions
(a)
How can I make cell values in a range to 4 decimal. Not formatting. I
have cell values in very big decimal. How can I change them to 4
decimal.
Say range("A10:E10")....

(2) I am using a formula in a range to set the its values.
Say range("B10:D10).formular1c1="=(rc[-1]-rc[-2])*100/rc[-2]"
Again I am getting huge big 1 decimal values. how can I get values upto
4 decimal point. Can I put a format inside this formula. or there is
other way.


--
jesmin
------------------------------------------------------------------------
jesmin's Profile: http://www.excelforum.com/member.php...o&userid=29540
View this thread: http://www.excelforum.com/showthread...hreadid=493138