C chris gail Dec 5, 2009 #1 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? I need the decimal point showing with the zeros after it!?!
× ×ž×™×›×ל (מיקי) ×בידן Dec 5, 2009 #2 Assuming 332.84 us in cell A1 - try these: =TRUNC(A1) =INT(A1) =ROUNDDOWN(A1,0) =FLOOR(A1,1) Micky
J Joe User Dec 5, 2009 #3 chris gail said: 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!?! Click to expand... Format as Number with 2 decimal places.
chris gail said: 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!?! Click to expand... Format as Number with 2 decimal places.
× ×ž×™×›×ל (מיקי) ×בידן Dec 5, 2009 #4 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"
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"
