Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why am I getting XXX error in text cell with word wrap turned on?
I am attempting to enter text into a cell in worksheet. The cell is
designated as a text cell, word wrap is turned on, the the cell is merged to six lines long. When I enter text it looks fine until I hit the Tab or Enter key, then all I get is a single line of XXXXXXX instead of the text. I have tried making the cell bigger, I have tried using hard returns in the body of the text. Nothing seems to work. Can anyone help me? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why am I getting XXX error in text cell with word wrap turned on?
Try changing the cell format from text to general
-- Gary's Student "HMF" wrote: I am attempting to enter text into a cell in worksheet. The cell is designated as a text cell, word wrap is turned on, the the cell is merged to six lines long. When I enter text it looks fine until I hit the Tab or Enter key, then all I get is a single line of XXXXXXX instead of the text. I have tried making the cell bigger, I have tried using hard returns in the body of the text. Nothing seems to work. Can anyone help me? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why am I getting XXX error in text cell with word wrap turned on?
Try changing the numberformat to General.
Format|cells|number tab HMF wrote: I am attempting to enter text into a cell in worksheet. The cell is designated as a text cell, word wrap is turned on, the the cell is merged to six lines long. When I enter text it looks fine until I hit the Tab or Enter key, then all I get is a single line of XXXXXXX instead of the text. I have tried making the cell bigger, I have tried using hard returns in the body of the text. Nothing seems to work. Can anyone help me? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use word wrap in a merged cell in excel 2000? | Excel Discussion (Misc queries) | |||
Omit the first word from a cell contain text | Excel Worksheet Functions | |||
####### within a wrap text cell. | Excel Discussion (Misc queries) | |||
how many lines can be in wrap text within a cell? | Excel Worksheet Functions | |||
how many lines can be in wrap text within a cell? | Excel Worksheet Functions |