dropping whole numbers
 

cell result = 444.876543 How copy to another cell but drop the whole numbers?

dropping whole numbers
 

=Mod(a1,1)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Asheret" wrote in message
...
cell result = 444.876543 How copy to another cell but drop the whole
numbers?

dropping whole numbers
 

Asheret,

If your number is in cell A1 and your result goes into B1.

In B1

= A1 - INT(A1)

will give you 0.876543.
Format B1 with custom format
..##############
to remove the leading zero.

Henry


"Asheret" wrote in message
...
cell result = 444.876543 How copy to another cell but drop the whole
numbers?

dropping whole numbers
 

Just to highlight the difference in VBA:

? 444.876543 mod 1
0

--
Regards,
Tom Ogilvy

"Anne Troy" wrote in message
news:83ac9$42c2bf32$97c5108d$8803@allthenewsgroups .com...
=Mod(a1,1)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Asheret" wrote in message
...
cell result = 444.876543 How copy to another cell but drop the whole
numbers?