Set a custom format (FormatCellsCustom) of £#,##0.00;£(#,##0.00)

--
HTH

Bob Phillips

"hrh frank" <hrh wrote in message
...
I want to format columns in excel using the currency icon in the toolbar.
When I click on this I get the accountancy formatting, ie the pound sign £
appears at the extreme left of the cell and not directly in front of the
number (eg £ 123.45 not £123.45). So how do I make the currency icon
work
properly ?