Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
=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? |
#3
|
|||
|
|||
=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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why am I getting .+ when I hit the decimal point? | Excel Discussion (Misc queries) | |||
Fixing a decimal point | Excel Discussion (Misc queries) | |||
How to clear decimal point? | New Users to Excel | |||
Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
decimal point override does not work | Excel Discussion (Misc queries) |