Find values to right of decimal place

[abbarition]

I have a need to find just the values that appear to the right of the decimal
place of a number. Is there a good way to do this other than using the InStr
function to search for a decimal place?

Thanks!

 

[pietlinden]

I have a need to find just the values that appear to the right of the decimal
place of a number.  Is there a good way to do this other than using theInStr
function to search for a decimal place?

Thanks!

Public Function GetRemainder(ByVal curNumber As Currency) As Currency
GetRemainder = curNumber - curNumber \ 1
End Function

I tried using Mod, but it only works with integers...

 

[Marshall Barton]

I have a need to find just the values that appear to the right of the decimal
place of a number. Is there a good way to do this other than using the InStr
function to search for a decimal place?

X - Fix(x)

 

[Klatuu]

You can use either the Int or the Fix function.

x = 123.45
x= x-Int(x)
?x
x=.45

 

[abbarition]

Thanks everyone! All three suggestions work great!