Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Decimals instead of whole numbers acroos pivot
Hi,
I have data with decimals. I need them to be whole numbers in a pivot table and then be the columns. Currently I have formatted the original data to be 1instead of 0.7 and 0.8 but am getting 4 column with 1 in them and the count associated with it. Any idea how I get just one column with all 0.1, .2etc in the correct field. -- Frenchie |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Decimals instead of whole numbers acroos pivot
In your PivotTable, double-click on the data field button that controls the
numbers your interested in. Change setting from Count to Sum. Now click on the number button, and change the format to number with 1 or 2 decimals. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Frenchie" wrote: Hi, I have data with decimals. I need them to be whole numbers in a pivot table and then be the columns. Currently I have formatted the original data to be 1instead of 0.7 and 0.8 but am getting 4 column with 1 in them and the count associated with it. Any idea how I get just one column with all 0.1, .2etc in the correct field. -- Frenchie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numbers & decimals | New Users to Excel | |||
Sorting numbers with two decimals | Excel Worksheet Functions | |||
Changing whole numbers into decimals | Excel Worksheet Functions | |||
How to calculate percentage acroos sheets in a workbook | Excel Discussion (Misc queries) | |||
routine to refresh all pivots in WB acroos several sheets | Excel Discussion (Misc queries) |