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

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