using=len()

[books4cars]

I am trying to count the number of characters in each cell column A. When I try to use autofill to apply =LEN(A2) in column B. The values all the way down come out the same as the first one. I must have inadvertently changed some setting but I can't figure out what,
thanks

LATEST SALES BROCHURE.xls
	A	B	C	D
2	93_Geo_Sales	12	0	T
3	96_Geo_Sales	12	0	T
4	97_Geo_Sales	12	0	T
5	92_Sonoma_Sales	12	0	T
6	96_Sonoma_Sales	12	0	T
7	96_Sierra_Sales	12	0	T
Sheet1

 

[Smitty]

Do you have absolute references? I.E. =LEN($A$1)

If so, you'll always reference that cell unless you remove the $'s.

Or is Calculation set to Manual? Tools-->Options-->Calculation...

HTH,

Smitty

 

[books4cars]

It is like this:

LATEST SALES BROCHURE.xls
	A	B	C	D
2	93_Geo_Sales	=LEN(A2)	0	T
3	96_Geo_Sales	=LEN(A3)	0	T
4	97_Geo_Sales	=LEN(A4)	0	T
5	92_Sonoma_Sales	=LEN(A5)	0	T
Sheet1

But it doesn't calculate the number of characters after the forst one. It seems to copy the same result all the way down.