Formatting Question
 

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.

Formatting Question
 

Tools--Options allows you to change default settings and apply them for
future instances of Excel.
--
Brevity is the soul of wit.


"Zecarioca" wrote:

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.

Formatting Question
 

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

Hank

"Dave F" wrote:

Tools--Options allows you to change default settings and apply them for
future instances of Excel.
--
Brevity is the soul of wit.


"Zecarioca" wrote:

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.

Formatting Question
 

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

"Dave F" wrote:

Tools--Options allows you to change default settings and apply them for
future instances of Excel.
--
Brevity is the soul of wit.


"Zecarioca" wrote:

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.

Formatting Question
 

I think you maybe can create your own style.

"Zecarioca" wrote:

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

"Dave F" wrote:

Tools--Options allows you to change default settings and apply them for
future instances of Excel.
--
Brevity is the soul of wit.


"Zecarioca" wrote:

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.