Data 4 decimal

  • Thread starter Thread starter jesmin
  • Start date Start date
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:D10).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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for copy and paste values 3
Timesheet - Formula 3
Access stripping decimal places in query 1
To store the formula in a string 4
changing decimal places according to formula result 6
using less than sign gets rid of decimals 4
Zeros after the decimal 7
Mail Merge - Thousand separators & Decimals 0

Back
Top