Redefining the $ icons format
 

In Excel 2003, I could r-click the $ icon and assign a macro from the
personal macro book to change the $ icon to format in a different dollar
format than the standard accounting dollar formatting one which I don't like.
I like the $ sign right next to the numbers vs. left aligned.

How do you do this in Excel 2007?

Redefining the $ icons format
 

G'day Todd

In 2007

Insert | Symbol

HTH
Mark

Redefining the $ icons format
 

Hi Mark,
I'm confused, what you mean Insert Symbol?

"NoodNutt" wrote:

G'day Todd

In 2007

Insert | Symbol

HTH
Mark

Redefining the $ icons format
 

"NoodNutt" wrote:

G'day Todd

In 2007

Insert | Symbol

HTH
Mark

Redefining the $ icons format
 

todd -

In Excel 2007, I choose Home | (Cells area) Format | Format Cells | Currency
....

Once I have the desired format in a cell, I use the Format Painter (paint
brush icon) to apply it to other cells.

Maybe someone else will help you with the macro.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"todd" wrote in message
...
In Excel 2003, I could r-click the $ icon and assign a macro from the
personal macro book to change the $ icon to format in a different dollar
format than the standard accounting dollar formatting one which I don't
like.
I like the $ sign right next to the numbers vs. left aligned.

How do you do this in Excel 2007?

Redefining the $ icons format
 

Todd

Brain Drain overnight while working.

Just follow Mike Middleton's lead and just format the cells as Currency
instead of Accounting.

Regards
Mark.