Round it, either round, roundup or rounddown depending upon your
requirements.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:729b594c161e3@uwe...
Hi I am trying to convert days into weeks and everythings fine until you
have
only 5 days showing, but this shows up as 0.7. The formula I am using is
D3/7 and i have also tried (D3-1)/7 and this shows 0.6.
--
Message posted via http://www.officekb.com