Zend certified PHP/Magento developer

How to format Cells like accounting except using Percentage sign

I am trying to create a hybrid format between Accounting and Percentage.

My cell value I am going to format contains a percentage. I would like to move the % Sign to left justified in the cell as it would be if it were formatted with Accounting.

I also want 0.00% values to be displayed as % - as it would with accounting

Example of Accounting Format (left) and Percentage Format (right). I would like to make a hybrid format per se.