Triming a number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Trim varying decimals from column of numbers 9
Summing Problem In A Pivot Table 1
Change number from multiple decimals to 2 3
Pivot table view does not show series data with decimals? 0
formula for decimal point 4
Convert number to text as displayed 3
pivot table loosing decimals (vba) 1

Back
Top