Currency format

  • Thread starter Thread starter Mike Gorton
  • Start date Start date
M

Mike Gorton

Hi,

Using Excel 2000. Is it possible to make the 'Currency' button behave in
the following way ?

Format the number £ sign leading, but not left justified.

e.g. Typing in 1.34 into a cell (make it 300 pixels wide), it gives '£
1.34'.

I'd prefer it simply to display the number £ sign leading, immediately
followed by the value (irrespective of how wide the cell/column is).
i.e. £1.34

I know it picks up the rule from the Regional Settings, but it doesn't make
the 'currency' button that useful at the end of the day. There's only 4
different types of format there. If you want the currency symbol before
the number, it ALWAYS left justifies it. It'd be more valuable if you could
(also) point it at a format predefined within Excel.

Cheers.
Mike.
 
one way:

I'm assuming you're talking about the "Currency Style" button.

click the button to apply the style. Choose Format/Style. Click
"Modify". Click "Custom". You should see something like

_(£* #,##0.00_);_(£* (#,##0.00);_(£* "-"??_);_(@_)

Remove the asterisk-space characters and click OK.

To make this apply to all new workbooks, create a new book. Make the
change above. Save the book as a template with the name Book.xlt in
the XLStart directory.
 
Back
Top