Leith Ross wrote:

Hello ZBC2,

Change the formula in A6 (Output Sheet) to this...

=TEXT(Sheet1!$A$1, Len(Sheet1!$A$1))

If this doesn't work for you, then I have no idea what the problem is.

Sincerely,
Leith Ross




The first expression you gave me displays the cell contents ok; the
problem is that it is still a 'formula'.
I want to convert the formula to the 'results' of the formula.

Bob