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
- Check In the Selection Only.
- Click Replace All.