Division results in 8.32957075464354E-03

Here is the equation:
401.25 / 48171.75
this results in this:
8.32957075464354E-03
how do I get the correct number which is: 120.05420560....
The total number is 28 decimals long. Basically I need 4 to 8 decimal places. I tried some different rounding functions I found but to no avail.


thanks

Quote:

---

Originally Posted by mojo69

how do I get the correct number which is: 120.05420560....

---

Microsoft Calculator's result for 401.25 / 48171.75 is: 0.0083295707546435410795746469663236

Quote:

---

Originally Posted by mojo69

The total number is 28 decimals long. Basically I need 4 to 8 decimal places. I tried some different rounding functions I found but to no avail.

---

Have you tried the Round function?

Code:

---

Round(401.25 / 48171.75, 8)

---

Er, there is no way that dividing a smaller number by a larger number is going to give a value of 1 or greater.

You have the two values reversed in your expression.

Definitely backwards

Code:

---

Debug.Print 48171.75 / 401.25

---

Yeilds 120.054205607477