this money has style...

  • Thread starter Thread starter medicenpringles
  • Start date Start date
M

medicenpringles

i have a problem with my "Currency Style" button. when i click it to
add that property to a cell, it makes the cell as Lira, and it moves
the currency sign to the far left of the cell, with the amount at the
right. is there a way to change this so that the button makes the
style like this: *$#,##0.00;[Red]-$#,##0.00;-;* ?

also, is there a way to create my own Style button and set my own
parameter to it, like *"Won";"Forfeit";"Lost"* ?

'cross-posted.' (http://www.excelforum.com/showthread.php?t=314106)
 
Format>Style. Open the dialog box and select "Currency" and "Modify"

Choose your style or type in what you want.

Not sure about the second question. Perhaps a macro or UDF?

Gord Dibben Excel MVP
 
Back
Top