MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Decimals


Posted by Brian on February 06, 2002 6:41 PM

After a calc I need to remove any number before the decimal.
Example,
Enter 12 in cell A1
Cell A2 =360/A1=30
Cell A3 =A2/9 = 3.33333333333
Cell A4 I need to Mutiply .3333333*18 =5.9999999
IS there a way to strip the 3 before the decimal by formating the cell some way?


Posted by Jacob on February 06, 2002 6:47 PM

Hi

This will remove all numbers before the decimal.

=MID(A1,FIND(".",A1,1),1000)

HTH

Jacob

Posted by Brian on February 06, 2002 7:05 PM

Thank you Jacob, for your fast respond and help!
Brian

Posted by Mark W. on February 07, 2002 7:04 AM

Better...

=MOD(A3,1)*18 After a calc I need to remove any number before the decimal.