I should have also mentioned that the paragraph formatting in the cell needs
to be left aligned.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"MJones" wrote in message
...
Hi,

I've placed a formula in a cell, but the dollar sign shows directly to the
left of the number. I choose the option $#,##0.00;($#,##0.00).

Is there a way to use the Excel type accounting format where there are
spaces between the dollar sign and the numbers so the dollar signs line up
evenly against the left side of the cell?

Thanks,

Michele