Hi!

Here's one way.

Select the range of array formulas.

In the formula bar precede the formula with an apostrophe to convert the
formula to text. Hit CTRL ENTER.

That will "break" the array but now you have to remove the apostrophe from
each individual formula to convert them back to formulas.

Biff

"Scott Calkins via OfficeKB.com" wrote in
message ...
OK I did a big stuped. I was trying to save a bit of time in going to
each
cell and converting it to a array by using thr ctrl-shift-enter. Not
thinking I decided to save some time and highlight a section of cells then
use the ctrl-shift-enter. After figuring out my blunder I went in to
change the cells back to the correct formula, but get the "cannot change a
array" error. How do I turn off the array on these blocks of cells?

--
Message posted via http://www.officekb.com