To use this function, choose Calc > Calculator.

Rounds a number to the specified number of decimals and converts it to text with or without commas.



For number, specify the number or column of numbers you want to round. For decimals, specify the number of places to retain.
  • If decimals = 1, Minitab rounds to the nearest tenth.
  • If decimals = 0, Minitab rounds to the nearest integer.
  • If decimals = -1, Minitab rounds to a multiple of ten.
  • If you don't enter a second argument, Minitab rounds to 2 decimal places.

Minitab inserts commas to separate some place values (hundreds and thousands, hundred-thousands and millions, and so on) in the converted text. If you don't want the commas to appear, enter a value of 1 for the optional third argument, no_comma. If you want the commas to appear, enter 0 or exclude the third argument entirely.


Column Calculator expression Result
C1 contains 2.354784 FIXED(C1,3) 2.355 (text value)
C2 contains 195833.5 FIXED(C2,-3,1) 196000 (text value)
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy