T
Tat
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?
another cell. How do I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
N Harkawat
=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)))
where cell A1 holds 13.75
and that 13.75 is NOT text
If its a text field then
=VALUE(RIGHT(A1,FIND(".",A1)))
B
Bob Phillips
=mod(a1,1)
D
Daniel CHEN
Try the following formula:
=A1-INT(A1)
A1 = 13.75, INT(A1) = 13, Result = 13.75-13 = 0.75
===== * ===== * ===== * =====
Daniel CHEN
Spreadsheet/VBA Specialist
[email protected]
www.Geocities.com/UDQServices
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
===== * ===== * ===== * =====
=A1-INT(A1)
A1 = 13.75, INT(A1) = 13, Result = 13.75-13 = 0.75
===== * ===== * ===== * =====
Daniel CHEN
Spreadsheet/VBA Specialist
[email protected]
www.Geocities.com/UDQServices
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
===== * ===== * ===== * =====
T
Tat
Thanks to all. All the solutions worked!