| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel formatted wrapped text displays as xxx in cell
Formatted cells: Tabs are set as follows:
Number = Text Alignment = Horizontal-General/Vertical-Bottom/Text Control-Wrap Text/Right-to-left-Context Font = True Type Borner = none Patterns = none Protection = none PROBLEM - Text OK in formula bar (fx), but displays as "xxxxxxxxxxxxxxxxx" in cell. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel formatted wrapped text displays as xxx in cell
Excel has a problem with cells that contain 255 but <1024 characters.
Fornat the cell to General and your ############## should go away. Gord Dibben MS Excel MVP On Thu, 26 Jan 2006 09:26:03 -0800, "Linda" wrote: Formatted cells: Tabs are set as follows: Number = Text Alignment = Horizontal-General/Vertical-Bottom/Text Control-Wrap Text/Right-to-left-Context Font = True Type Borner = none Patterns = none Protection = none PROBLEM - Text OK in formula bar (fx), but displays as "xxxxxxxxxxxxxxxxx" in cell. Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrapped text is not displaying in Excel | Excel Discussion (Misc queries) | |||
| What does ####### mean in an Excel cell? The cell contains text. | Excel Discussion (Misc queries) | |||
| Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
