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.
