Of course - my mistake (didn't notice the exact number)
In that case he can use: RoundUp or Ceiling as well...
Micky


והמשך/×™, ×*×�, לקרו×� ×�ת השורה הב×�×”:
***********
×�×� תגובתי עזרה לחץ/×™, ×*×�, על <כן בפס ×”×�ופקי התחתון!
***********
מיכ�ל �בידן
מ×*הל פורו×� "×�ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"


"David Biddulph" wrote:

Wouldn't those give 332 instead of 333, Micky?
--
David Biddulph

"????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message
...
Assuming 332.84 us in cell A1 - try these:
=TRUNC(A1)
=INT(A1)
=ROUNDDOWN(A1,0)
=FLOOR(A1,1)
Micky


"chris gail" wrote:

How do I round off a number to 333.00 instead of 332.84? I need the
decimal
point showing with the zeros after it!?!


.