Formatting Question

Z

Zecarioca

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.
 
D

Dave F

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

Zecarioca

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

Hank

I think you maybe can create your own style.

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