| 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 |
| 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) | |||
Threaded Mode
