| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Number in Invoice | New Users to Excel | |||
| From Template Save As Help | New Users to Excel | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
