The two digits you want "pulled"... do you want them as Text or as Numbers.
I ask because there is a question of what to give you for something like
123.02 and 123.20, or 12.00, if you want them to be numbers after they are
"pulled".

Rick


"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