1 Reply Latest reply on Dec 4, 2015 8:52 AM by taciac

    Negative values formatting issue. 

    swaraj_mandla

       When i am trying to compare two period in sitecatalyst for pages report some of  the change values are negative numbers. When i tried downloading them in to Excel the format of this number is not proper. E.X:- (-4) is given as('-4.000000) in excel report. Please help me on this

        • 1. Re: Negative values formatting issue. 
          taciac Level 4

          Swaraj Mandla wrote...

           When i am trying to compare two period in sitecatalyst for pages report some of  the change values are negative numbers. When i tried downloading them in to Excel the format of this number is not proper. E.X:- (-4) is given as('-4.000000) in excel report. Please help me on this

           

          Hi Swaraj, 

          You can change the formatting of the number by right clicking on the cell (or entire column) > format cell > number > change the decimal places to zero. That will show the number as a whole number in the report. 

          - Tacia