ExcelBanter - Triming a number

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Triming a number (https://www.excelbanter.com/excel-worksheet-functions/128977-triming-number.html)

Keith

Triming a number

I have a list of numbers that I want to pull into a pivot table.
Unfortunately the numbers are all in the format of 1.253333333333333333333
or 12.24588888

If I format the cells to only show 2 decimal places they look fine but the
pivot table shows the full values.

How can I trim the values to just the 2 decimal places?

Gary''s Student

Triming a number

=ROUND(A1,2)
--
Gary''s Student
gsnu200703

"Keith" wrote:

I have a list of numbers that I want to pull into a pivot table.
Unfortunately the numbers are all in the format of 1.253333333333333333333
or 12.24588888

If I format the cells to only show 2 decimal places they look fine but the
pivot table shows the full values.

How can I trim the values to just the 2 decimal places?

All times are GMT +1. The time now is 10:18 AM.