Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merged cells text 255 chars causes "#" to be displayed
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text stored in a cell is displayed as a string of "#####..." | Excel Discussion (Misc queries) | |||
sort spreadsheet, "merged cells" comes up. Find cells? Unmerge ? | Excel Discussion (Misc queries) | |||
How to turn off the large text "Page 1" etc, displayed in spreadsh | Excel Discussion (Misc queries) | |||
When is "?" really a "?" (.SaveAs with Chinese chars) | Excel Programming | |||
Convert "merged" cells to "CenterAcrossSelection" | Excel Programming |