dropping whole numbers

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

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"Asheret" <Asheret@discussions.microsoft.com> wrote in message
news:789802B4-E13E-4682-BEDB-9AC97DC7989E@microsoft.com...
> cell result = 444.876543 How copy to another cell but drop the 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" <Asheret@discussions.microsoft.com> wrote in message
news:789802B4-E13E-4682-BEDB-9AC97DC7989E@microsoft.com...
> cell result = 444.876543 How copy to another cell but drop the whole
> numbers?

Just to highlight the difference in VBA:

? 444.876543 mod 1
0

--
Regards,
Tom Ogilvy

"Anne Troy" <ng@officearticles.com> wrote in message
news:83ac9$42c2bf32$97c5108d$8803@allthenewsgroups.com...
> =Mod(a1,1)
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Asheret" <Asheret@discussions.microsoft.com> wrote in message
> news:789802B4-E13E-4682-BEDB-9AC97DC7989E@microsoft.com...
> > cell result = 444.876543 How copy to another cell but drop the whole
> numbers?
>
>