Negative values formatting issue.

Avatar

Avatar
Validate 1
Level 1
swaraj_mandla
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
swaraj_mandla
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
swaraj_mandla
Level 1

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)

Avatar

Avatar
Validate 1
Level 7
taciac
Level 7

Likes

17 likes

Total Posts

341 posts

Correct reply

188 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 7
taciac
Level 7

Likes

17 likes

Total Posts

341 posts

Correct reply

188 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
taciac
Level 7

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)