How do I round numbers in a column to 2 decimal places?

  1. Select the column that you want to round. Go to Search | Replace…. Select the Number Range option.
  2. In the Enter Number Range dialog, select the Decimal Numbers option and click OK. This will add [ , ]to the Find field which indicates “all numbers”.
    Enter Number Range
  3. In the Replace with field, enter \J parseFloat( \0 ).toFixed(2). This JavaScript expression will round each cell value to 2 decimal places. Feel free to change the “2” to a different decimal place.
  4. Check In the Selection Only.
    Replace
  5. Click Replace All.