Nick,

It's not merged cells that's causing the problem,
Appears to be the use of @ in the (custom) numberformat when
applied to text 255 char.

Also i cant see that you have a problem:
I've never heard of a valid barcode that was longer than 255 chars..
... so just insert multiple barcodes in multiple cells.

or start the string with an apostrophe or vblf/linefeed

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


NickHK wrote :

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