I have an Excel '02 project with a lot of form data stemming from both
other work sheets and other excel files.

I now wish to convert the calculated data to neutral values in a heck
of a lot of cells.

For sake of example, in a cell there is the form:
=[OtherFile.xls]A1+B1
and it triggers out, say, the value 24.8. It could also be text, a
name, etc.

How do I now get converted to the pure value 24.8, in stead of the
form, with a single shortcut? And for a heck lot of cells, perhaps a
large selection all at once. I have forgotten which keystroke does it,
and for some reason I can't look the damn thing up in helps, etc. It's
too much to convert all cells manually, and it leaves room for human
error, etc.

Chris Engelbrecht,
Copenhagen