Negative values formatting issue.

swaraj_mandla

01-12-2015

 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

Accepted Solutions (1)

Accepted Solutions (1)

taciac

04-12-2015

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

Answers (0)