How do I round off a number to 333.00 instead of 332.84?
 

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!?!

How do I round off a number to 333.00 instead of 332.84?
 

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!?!

How do I round off a number to 333.00 instead of 332.84?
 

=ROUND(A2,0) and format as number with 2 decimal places.
--
David Biddulph

"chris gail" <chris wrote in message
...
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!?!

How do I round off a number to 333.00 instead of 332.84?
 

"chris gail" <chris wrote:
How do I round off a number to 333.00 instead of 332.84?

=ROUND(A1,0)


I need the decimal point showing with the zeros after it!?!

Format as Number with 2 decimal places.

How do I round off a number to 333.00 instead of 332.84?
 

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!?!

How do I round off a number to 333.00 instead of 332.84?
 

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!?!


.