percentage formatting with a comma

[charliec]

Hi, I have a cell with an IRR formaula which gives a result of 2750% in it and all I want to do is have commas put in to so it is easier to read. I'd like it to be 2,750%. I tried to use the "format cell" command and look under the "percentage" option but it doesn't give me any other options like in the "number" options.

I am using Excel 2012 in W7. Thanks.

 

[AhoyNC]

Try this.

Format Cell - Custom
Enter:
#,#0%

 

[charliec]

Worked like a charm. Thanks!

Try this.

Format Cell - Custom
Enter:
#,#0%