You likely copied one sheet to the other. Excel truncates as you've seen.
Bug/oversight/whatever. Best bet would be to select the TEXT in the cell &
paste it to the other.
Maybe wait until Excel 2009!

"Steve_zsli" wrote in message
...
I have 2 worksheets in separate workbooks that are basically identical. In
one I have text entries that display all my text (255). In the other the
thext has been truncated to 255 for display.
Why can't I get this limit removed??