Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Negative values formatting issue.

swaraj_mandla
Level 1
Level 1

 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 Accepted Solution
taciac
Correct answer by
Level 9
Level 9

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

View solution in original post

1 Reply
taciac
Correct answer by
Level 9
Level 9

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

View solution in original post