1 Reply Latest reply on Oct 29, 2012 3:32 PM by Jun Kim

    how to display $ sign for grand totals

    Venkata Kagitala

      Hi Folks,

       

      I would like to display $ sign for grand totals only, not for the rows /column values. how to do that.

       

      Your help is greatly appreciated.

       

      thanks

      Reddy

        • 1. Re: how to display $ sign for grand totals
          Jun Kim

          Hi Venkata,

           

          You can change the number format at a different level from the row/column values.

           

          To do this:

          1) right-click your Grand Total value and choose Format...

          2) In Grand-Totals change the drop-down for Numbers: to Currency.

          3) The Default section will change your number format for columns/rows while the Grand Totals will change it only for the Grand Total value.