I have some data that was imported into Excel from a large databse system
(name unknown). This data acts very strange: it looks numeric but doesn't
act like it. It may even act numeric for a function or two, then 'lose" its
ability to be numeric. I've gone through various conversions that the Help
has described, but to no avail. Specifically, I'm trying to do a "countif"
adding some of the "numbers" in the 200 range, e.g. countif 200. The cell
returns the formula, that is: countif 200. I've done a lot of Excel work,
but I have never had data work like this. I've copied in some data from the
SS.

F Native Amer/AK Nat. n n y n rml n
N n N Y N N 4 189 BAS 182 BB 191 BAS
M Caucasian n n n n n n N n N Y N N 4 184 BB
M Caucasian y n y n rml n N n N N N N 4
M Caucasian n n n n n n N n N N N N 4
M Caucasian y n y n n n
N n N N N N 4 200 Prof 211 Prof 203 Prof
M Caucasian y n n n n n
N n N N N N 4 177 BB 190 BAS 184 BB
M Caucasian y n y n rml n N n N N N N 4
M Caucasian y n y n n n
N n N N N N 4 182 BB 179 BB 185 BB
--
Bye Now