| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up numbers in a pivot table
I have a long column of numbers in a pivot table.....all whole
numbers....that I would like to round up to the nearest 5.....ie: 52 = 55 68 = 70 33 = 35 any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Divide 2 pivot table numbers | Excel Worksheet Functions | |||
| rounding off numbers gives an E in pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table formatting numbers | Excel Worksheet Functions | |||
| Negative Numbers in a Pivot Table | Excel Worksheet Functions | |||
| Rounding to the nearest quarter (decimal) in a Pivot table | Excel Discussion (Misc queries) | |||
![time conversion[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
