View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Keith Keith is offline
external usenet poster
 
Posts: 262
Default 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?