How do I round numbers in a column to 2 decimal places?
- Select the column that you want to round. Go to Search | Replace…. Select the Number Range option.
- 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”.
- 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. - Check In the Selection Only.
- Click Replace All.