formatting numbers
 

result in cell = 445.987654 How do I copy just the remainder .987654 to
another cell, dropping the whole numbers?

formatting numbers
 

=mod(a1,1)
or
=A1-int(a1)



Asheret wrote:

result in cell = 445.987654 How do I copy just the remainder .987654 to
another cell, dropping the whole numbers?

--

Dave Peterson

formatting numbers
 

Put the following formula in the cell you would like the results in
Let's assume A1 is where the number 445.985343 is

=a1 - int(a1)

--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Asheret" wrote:

result in cell = 445.987654 How do I copy just the remainder .987654 to
another cell, dropping the whole numbers?