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?

=mod(a1,1)

--
HTH

Bob Phillips

"Tat" <Tat@discussions.microsoft.com> wrote in message
news:ED34A2BB-BF41-4F15-853A-3516EB5496A9@microsoft.com...
> 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
UDQServices@Gmail.com
www.Geocities.com/UDQServices
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
===== * ===== * ===== * =====

"Tat" <Tat@discussions.microsoft.com> wrote in message
news:ED34A2BB-BF41-4F15-853A-3516EB5496A9@microsoft.com...
> 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" <Tat@discussions.microsoft.com> wrote in message
news:ED34A2BB-BF41-4F15-853A-3516EB5496A9@microsoft.com...
> 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?