Displaying only digits after the decimal point
 

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?

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

=mod(a1,1)

--
HTH

Bob Phillips

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

Try the following formula:

=A1-INT(A1)
A1 = 13.75, INT(A1) = 13, Result = 13.75-13 = 0.75

===== * ===== * ===== * =====
Daniel CHEN

Spreadsheet/VBA Specialist

www.Geocities.com/UDQServices
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
===== * ===== * ===== * =====

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

Thanks to all. All the solutions worked!

"Tat" wrote:

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?