PIVOT TABLE HELP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michele - 28 Nov 2006 21:02 GMT

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 to this Message

Roger Govier - 28 Nov 2006 21:45 GMT

Please see reply to your post in excel.misc

Please do not multipost.

Signature

Regards

Roger Govier

>i have a spreadsheet with columns ( Vender, Month, Amount ) i'm trying
>to set
[quoted text clipped - 3 lines]
> something
> like 1,2,3,4,5. How do i keep my AMOUNT as currency

Reply to this Message