Making AutoFit Permanent in Excel 2003

Jynx980

Senior member
Jan 10, 2001
604
0
0
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

Golden Member
Nov 4, 1999
1,697
0
76
=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.