It only misbehaves if first the text in A2 is shorter than the cell
subsequently autowrap is switched on and subsequently the text in A2 i
modified to make it longer than the cell.
If you start already with a text longer than the cell width, it behave
just fine. So could you please try the exact sequence as described i
the original post?

Thanks,
Jurry.

Sandy V wrote:
*Also using for example "bchsdbcjhbcjhbvmbhmvbjbv" it
gives the same problem.... :(

Strange. If my formula cell is formated with WrapText, and
references a cell containing text, it wraps fine for me.
If it references a cell containing a number then it does
not, without a fix as I suggested.

Regards,
Sandy

Sandy V wrote:
[b]I think WarpText only wraps text!

If it's OK to convert your number to text, try

="'" & A2

Regards,
Sandy


---
Message posted from http://www.ExcelForum.com/

.


--
Message posted from http://www.ExcelForum.com