Hi

Each time I format a cell as a "Number" I have to go through a series of 3
clicks: decrease decimal to 0, add separator comma, choose the format for
Negative values. Is there a way to have Excel automatically have my favourite
as "default", so I can just hit Format Cells-- Number and nothing else? I
know I can create an easy macro to accomplish this in just one click, but I
want to know if I can change the Excel defaults.

On the same line, whenever I create a new pivot table i'd like the
"automatically format table" to be unclicked (default is clicked.)

Also, on a Pivot Table, when dragging numerical fields into the Data area,
Excel comes up with a Count of the field about 90% of the times, instead of a
Sum, so I have to go and change manually each and every field to Sum (I need
a sum about 95% of the times). I don't know how Excel decides whether to use
Sum or Count, but is there a way to make it use count always?

Thanks