What is the format to get the 5 decimal places but without rounding off?
Here's the sample:
textbox1 / textbox2 = textbox3
Textbox1 = 3768.62
Textbox2 = 134
Textbox3 should be only 28.12402
I have this below formula but this still it's rounding.
Private Sub TextBox1_Change()
If IsNumeric(TextBox1) And IsNumeric(TextBox2) Then
TextBox3.Value = Format(TextBox1 / TextBox2, "####.00000")
Else
TextBox3.Value = ""
End If
End Sub
Private Sub TextBox2_Change()
If IsNumeric(TextBox1) And IsNumeric(TextBox2) Then
TextBox3.Value = Format(TextBox1 / TextBox2, "####.00000")
Else
TextBox3.Value = ""
End If
End Sub
Bookmarks