Return value from right of decimal point

[Syerston]

I need to check if a number has a vlaue to the right of the decimal point, and return that part of the number.

Any help as always greatly appreciated. John

 

[oharab]

se:
right(sValue,len(sValue)-instr(sValue,".&quot)

where sValue is the string the the decimal point in it.

B
----------------------------------
Ben O'Hara
Home: bpo@RobotParade.co.uk
Work: bo104@westyorkshire.pnn.police.uk
Web:

http://www.RobotParade.co.uk

----------------------------------

 

[Syerston]

Ben

Thanks for replying

What you gave me works fine for returning the digits to the right of the decimal. However, if my calculation returns an integer(ie no decimal point) the function returns the value of the integer. Any ideas. John

 

[MissTipps]

How about this: First use the Fix function to obtain the integer value of the number, then subtract that from your original value.

so:

ValueToRight = myValue - Fix(myValue)

Any good

Clare

 

[Syerston]

Clare

Its not quite what I was looking for but with a tiny bit of tweaking I think it is going to work.

Thank you very much. John