Re: currency icon (british pounds)

Thanks BOB. your suggestion does work, but would take 5 keystrokes. I want
to be able to highlight a column, click on a toolbar icon, and for all the
numbers to be then formatted as currency. So I need to customise a toolbar
icon to do this. any ideas ?

"Bob Phillips" wrote:

> Set a custom format (Format>Cells>Custom) of £#,##0.00;£(#,##0.00)
>
> --
> HTH
>
> Bob Phillips
>
> "hrh frank" <hrh frank@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:FBC43670-2191-435F-9F3C-11E5B51E78CF@xxxxxxxxxxxxxxxx
> > 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 ?
>
>
>
.