Percentage question

[818jaime]

I'm exporting from AVAYA CMS, when I export a report into excel
example:
78.50 when I go to format to add % it displays 7850.00% How can I fix
this to read 78.50%

 

[Ch.Wolfram]

Hi,

The Problem is, that percents are values between 0,00 and 1,00.

Workaround:
Create a "user defined" format in Excel for this column: 0,00 "%"

 

[Ch.Wolfram]

Sorry - you need a point, not a comma.

 

[Michael Bednarek]

I'm exporting from AVAYA CMS, when I export a report into excel
example:
78.50 when I go to format to add % it displays 7850.00% How can I fix
this to read 78.50%

In "Format Cells" (Ctrl+1), select category Custom, type
#.## "%"
in the box "Type:".

 

[818jaime]

In "Format Cells" (Ctrl+1), select category Custom, type
 #.## "%"
in the box "Type:".

Thank you

 

[818jaime]

Hi,

The Problem is, that percents are values between 0,00 and 1,00.

Workaround:
Create a "user defined" format in Excel for this column:   0,00 "%"

818jaime schrieb:




- Show quoted text -

Thank you