View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Michele Michele is offline
external usenet poster
 
Posts: 90
Default 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