Can we get a left justified "$" and a right justified Number Format in Financial Reporting?

Experts and Guru's,

My client likes the "Accounting" Number format available in MS Excel.  This is the format that will put numbers to two decimals so that the decimal itself is lined up in all rows and the numbers are right justified, and adds a "$" symbol that is left justified.  In Financial Reporting, when we add the "$" as a prefix, it is entered as the first charector of the right justified number.  Therefore, in the MS Excel "Accounting" Number format, the "$" is lined up on the far left in all cells with a gap between the symbol and the number.  In Financial