Select the cell with the formula.

Double click on that cell then, hold down both the CTRL key and the SHIFT
key then hit ENTER.

If done properly the formula will be enclosed in squiggly braces { }. You
can't just type the braces in, you MUST use the key combo of
CTRL,SHIFT,ENTER. Also, if you edit the formula (which is what you did when
you double clicked the formula cell) it must be re-entered as an array using
the key combo.

Biff

"GaryC" wrote in message
oups.com...
Well at least I got the formula pasted in, but it says it has an error.