=a1-int(a1)
where cell A1 holds 13.75
and that 13.75 is NOT text
If its a text field then
=VALUE(RIGHT(A1,FIND(".",A1)))
"Tat" wrote in message
...
If i have a '13.75' in a cell, I would like to display just the .75 in
another cell. How do I do this?
|