Display numbers right of decimal

[M626]

I need to retreive number right of the decimal place.

example: 7.45
I need to get .45 and display it in text box.

Can anyone help?

 

[CCLINT]

Text1.Text = 7.45 - Int(7.45)

 

[RalphBrown]

Try:

MyNumber = 7.45
MyTextBox.text = right(str(MyNumber), 3)

Hope this helps,
Ralph

 

[MatDavies]

CCLINT, ever come across this before? I just tried your method and got quite a strange result.

debug.print 8.97 - int(8.97)

gave me this:

0.970000000000001


Any ideas?

Matt

 

[Swi]

Try:

Test = 7.45
Text1.Text = Mid(Test, InStrRev(Test, ".&quot) Swi

 

[johnwm]

CCLINT's version will work with almost any number / decimal places.

RalphBrowns will only work with 2 dp exactly with no trailing zeroes. If you try with 7.10 you will get 7.1 Let me know if this helps

Check out FAQ222-2244
'There are 10 kinds of people in the world: those who understand binary, and those who don't.'

 

[CCLINT]

MatDavies
When calculating floating-point numbers you may run into these problems.

Debug.Print CCur(8.97) - Int(8.97)

will be as expected: return 0.97