[Bug?] Float to Label.Text

[Discorez]

I have a rounded float variable (in debugger I see it as 7.908), and I show
result in two labels, but I receive different results:

Sub btCalc_Click
   Dim Rez As Float
   
   Rez = Round2(7.907999456789, 3) ' Rez debugger shows as "7.908"
   lbResult2.Text = Rez                    ' shows as "7.908"
        lbResult.Text = Rez & " mV"          ' shows as "7.907999456789 mV"
End Sub

:BangHead: Why?

test code is attached


Upd.

lbResult.Text = NumberFormat(Rez, 0, 3) & " mV"

It works correctly, but the situation which I described above is unclear for me...

 

[klaus]

If you look at the help Round2 returns a Double.
But you define a Float in the routine.
This works:

Sub btCalc_Click
    Dim Rez As Double
    
    Rez = Round2(7.907999456789,3)
    lbResult.Text = Rez & " mV"
    lbResul2.Text = Rez
End Sub

But I agree it looks a bit strange.

Best regards.

 

[Erel]

The best way to format a number is with NumberFormat(2) keywords.

What you are seeing is a result of a rounding error (because you used Float instead of Double). In the first case the number is first converted to double and in the second case it doesn't.

 

[Discorez]

Erel, Claus, thanks.
I understood this.
But why debugger shows value for Rez variable as 7.908 instead 7.907999456789?
It should be?

 

[Erel]

This is related to the way that the number is converted to string by the debugger.