J
jesmin
Hi There: 2 questions
(a)
How can I make cell values in a range to 4 decimal. Not formatting.
have cell values in very big decimal. How can I change them to
decimal.
Say range("A10:E10")....
(2) I am using a formula in a range to set the its values.
Say range("B10
10).formular1c1="=(rc[-1]-rc[-2])*100/rc[-2]"
Again I am getting huge big 1 decimal values. how can I get values upt
4 decimal point. Can I put a format inside this formula. or there i
other way
(a)
How can I make cell values in a range to 4 decimal. Not formatting.
have cell values in very big decimal. How can I change them to
decimal.
Say range("A10:E10")....
(2) I am using a formula in a range to set the its values.
Say range("B10
10).formular1c1="=(rc[-1]-rc[-2])*100/rc[-2]"Again I am getting huge big 1 decimal values. how can I get values upt
4 decimal point. Can I put a format inside this formula. or there i
other way