software

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(quot;A10:E10quot;)....

(2) I am using a formula in a range to set the its values.
Say range(quot;B1010).formular1c1=quot;=(rc[-1]-rc[-2])*100/rc[-2]quot;
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: www.excelforum.com/member.php...oamp;userid=29540
View this thread: www.excelforum.com/showthread...hreadid=493138Hi Jesmin,

=ROUND(A1,4)

--
Kind regards,

Niek Otten

quot;jesminquot; gt; wrote in
message ...
gt;
gt; Hi The 2 questions
gt; (a)
gt; How can I make cell values in a range to 4 decimal. Not formatting. I
gt; have cell values in very big decimal. How can I change them to 4
gt; decimal.
gt; Say range(quot;A10:E10quot;)....
gt;
gt; (2) I am using a formula in a range to set the its values.
gt; Say range(quot;B1010).formular1c1=quot;=(rc[-1]-rc[-2])*100/rc[-2]quot;
gt; Again I am getting huge big 1 decimal values. how can I get values upto
gt; 4 decimal point. Can I put a format inside this formula. or there is
gt; other way.
gt;
gt;
gt; --
gt; jesmin
gt; ------------------------------------------------------------------------
gt; jesmin's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29540
gt; View this thread: www.excelforum.com/showthread...hreadid=493138
gt;