I have one cell on a template that displays all "#########....." when I
insert more than 255 characters, although all text is present and can be
edited.
Merged cells are formatted as Text, Wrap=true, merged over 10 columns and 2
rows.
No validation or conditional formatting applied. No code running upon
change.
Reading:
http://office.microsoft.com/en-us/as...992911033.aspx
shows no reason for this behaviour.
If the merged cells are formatted as General, then text is displayed as
usual.
As barcodes may be inserted in this area, I need it formatted as Text.
NickHK