View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

=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?