I John,
What about setting the Wrap Text through code:
Dim cell as range
...
cell.WrapText = true
(whether cell is a single cell or a multi-cell range)
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"M John" wrote:

Hello,
I'm having trouble how to automatically correct this problem.

The output from a macro looks like this: 2.167�ª1.033�ª9.604
where the �ª's are "alt-enter", which is to say that this should look like:
2.167
1.033
9.604

If I...
1) double click in the cell, as if to edit it, and then hit the "enter" key,
it's corrected
2) (similarly) hit the "F2" key, and then "enter" it's also corrected

Is there something that I can add to the macro to correct this in the macro?

Many thanks,
M John