Custom % Format Help Request

[dbsbender]

I am trying to create a custom number format.
Here is what I have come up with: 0.00%;[Red]-0.00%
The problem is, it has no "," it would display as 23555555.6% or -2355555.6%(negative needs to be red)

I need it to display as: 23,555,555.6% or -23,555,555.6%(negative needs to be red)
How would this be written?

Additionally, I have occasion to "abbreviate" in the following format:
23.55MM% or 1.5M% or -23.55MM% or -1.5M%(negative needs to be red)
For currency, I have it written in this manner: Currency: [>=1000000] $#,##0.0,," MM";[>0] $#,##0.0," M";[Red]($#,###," M")
I just freeze when trying to convert to percentage.

Can anyone help?

Thank you so much in advance for your assistance.

[vogel997]

Try custom formatting #,##0.0%

[vogel997]

Try custom formating #,##0.0% and or #,##0," mm"%

[dbsbender]

Thank you so much. So easy, yet beyond me tonight.