Formatting Question

[Guest]

How can I change the default setting for cell formatting - even on existing
spreadsheets. I wanted all numbers to be inputed as currency with 0 decimal
places, but it always defaults to numbers with 2 decimal places. I know I
can change the formatting after the fact, but I wanted this to be the default
setting.

Thanks for any help.

 

[Guest]

Tools-->Options allows you to change default settings and apply them for
future instances of Excel.

 

[Guest]

You can go to FORMAT -> Style -> choose Currency [0] from style name

Hank

 

[Guest]

That works to change the decimal places, but I also wanted to change the
default category (i.e. accounting, currency, number). Any thoughts?

 

[Guest]

I think you maybe can create your own style.

That works to change the decimal places, but I also wanted to change the
default category (i.e. accounting, currency, number). Any thoughts?