This works for me

=LEFT((A1-INT(A1))*100,2)

--

Regards,
Nigel




"Hamed parhizkar" wrote in
message ...
Is there anyway to pull out certain digits based on rounding?

In A1...143.265 So my if would be =if(A1<0,A1,"")

However I only want the 2 digits after the decimal to pull. I know I can
do
a middle, or right formula but how would this work if I had several rows
some
with 1.199 and others with 145.258?

Please help