Hi guys,

Is there an opposite of Trunc command in Excel?

i.e

If i Trunc(1.2222)

I get "1"


But i just want the "2222"

any ideas?

thanks

aboo

Hi aboo

How about =Mod(1.222,1) ??

or what MOD it is derived from 1.22-1*Int(1.222/1)

or, in this case, just 1.222-Int(1.222)

If you have negative numbers this will need considering?

It's all in excel help.

MTB

thanks Mike