View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?