Dohhhh - Cheers Niek :-)
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Niek Otten" wrote in message
...
Minor addition:
For the numeric data, put a 1 in an empty cell somewhere,
EDITCOPY,
select all your data, do edit / Paste special / Multiply
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Ken Wright" wrote in message
...
Your data has come in as text, that's all.
For the numeric data, put a 1 in an empty cell somewhere, select all
your
data, do edit / Paste special / Multiply
For the formulas, select the entire sheet, do format / cells / general
or
number etc, then just renter the formulas. If you have lot sof them,
just
select all and do edit / replace, replacing = with =. Sounds daft i
know
but it works.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--
"Be Frank" wrote in message
...
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
|