Another approach: select column and then Data Text to Columns
Finish.

p wrote:

as i understood your practical question..
i test run one sample
on column A, format cell into text.
i type =1+1 cell appears as =1+1
then i copy Column A paste special values to column B
I select whole column B
Click EditFind
Find =
Replace =
replace all
then see result as 2 on all cells of column B.

logistics is the name not the brainbox.



"Bart Wolf" wrote:

In anExcel 2000 workbook I have created a series of formulae in a column
using a text string. To create the text string I used a different formula
initially to pull together a mixture of text and the contents of cells in
another column. (There is a very good reason for this.) I then copy and
special paste the "text strings" in the new column as values. At this point
all the cells appear to be formulae (using cells from another sheet in the
same workbook), but they do not compute - not until I click on each
individual cell with my mouse and press return. THEN the newly created
formula in one cell computes, and returns the answer. I can only perform this
task for one cell at a time: I can't get the whole column of newly created
formulae to compute all at once.

If you understood this, you're a real brain box, but is there a solution to
getting all the column to compute at once?