Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limited character display
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limited character display
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?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limited character display
Column width is limited to 255 characters. Do you have the cell format
alignment set to allow wrap? -- David Biddulph "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?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limited character display
Actually I did not copy the sheet specifically because I know it trucates. I
copied the text directly. It is all there it simply does not display and I get ### with 256 characters. "Bob Umlas" wrote: 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?? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limited character display
I have the alignment set to wrap. The taxt is there but even with wrap I get
one line of ### to what ever the column width is set to. If I reduce the content to 255 characters then I get normal wrapped text. "David Biddulph" wrote: Column width is limited to 255 characters. Do you have the cell format alignment set to allow wrap? -- David Biddulph "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?? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limited character display
Try formatting the cell as General (or anything but Text).
Steve_zsli wrote: 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?? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Display characters present after a specific character | Excel Discussion (Misc queries) | |||
How do I display limited columns in excel? | Excel Discussion (Misc queries) | |||
Character display problem importing into Excel | Excel Discussion (Misc queries) | |||
Want to input one character to cause related string to display in. | Excel Worksheet Functions |