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 |