Making AutoFit Permanent in Excel 2003

[Jynx980]

I would like to have autofit(the adjustment of a cell to fit text) come on by default. Any options for that?

I also want to know how to calculate a running total for an entry of non-numerical numbers such as a date. Example:

1/2/2006 Total Days
1/3/2006
1/5/2006

I want the total numbers of days to appear in a cell as a running total but there is no real numerical data so I am not sure how to assign a number to it or add the total up. TIA

 

[TSDible]

=COUNTA(A:A)

Will count everything in column A as long as there is an entry. I'm not sure how exactly you want to count.

As for changing the Excel default of cells, I will have to look in to that some more.

 

[Jynx980]

Thank you. =Count did what I wanted it to.