| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
PIVOT TABLE HELP
i have a spreadsheet with columns ( Vender, Month, Amount ) i'm trying to set
up my table as follows: Column Fields are MONTH, Row Fields are Vender, and Data Items are AMOUNT. But when i put the AMOUNT in it changes to something like 1,2,3,4,5. How do i keep my AMOUNT as currency |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
PIVOT TABLE HELP
Please see reply to your post in excel.misc
Please do not multipost. -- Regards Roger Govier "Michele" wrote in message ... i have a spreadsheet with columns ( Vender, Month, Amount ) i'm trying to set up my table as follows: Column Fields are MONTH, Row Fields are Vender, and Data Items are AMOUNT. But when i put the AMOUNT in it changes to something like 1,2,3,4,5. How do i keep my AMOUNT as currency |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display the source for a pivot table page field | Excel Worksheet Functions | |||
| Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
Linear Mode
