Displaying only digits after the decimal point

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
=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)))
 
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"
===== * ===== * ===== * =====
 
You must log in or register to reply here.

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
Incorrect result for simple SUM formula 9
Display a digit before or after the decimal point in another cell 7
CONCATENATE 3
Decimal point in general format 1
Count digits before decimals and after decimals 4
Wrong Number Results 4
Addition errors with Decimal Places 5

Back
Top