Displaying only digits after the decimal point

G

Guest

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?
 
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)))
 
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
(e-mail address removed)
www.Geocities.com/UDQServices
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
===== * ===== * ===== * =====
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell reference in formula string displays abbreviated value 2
Display a digit before or after the decimal point in another cell 7
Count digits before decimals and after decimals 4
Decimal point in general format 1
CONCATENATE 3
Two digit number with one decimal, or three digit number 2
how to copy displayed value only? 1
Addition errors with Decimal Places 5

Top