| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text Wrapping
This is so basic im embarrassed to ask but ive done this hundreds of times
before and no matter what, I cant get it working. Ive a cell with text in it too long for the cell B5. Ive formatted the cell to wrap text and used autofit but its displaying ######################. The text is all there as i can see it in the editing tooblar when i click on the cell. I have other cells where i have the same issue and other cells where the wrapping has worked properly. Its driving me mad. I can only assume there is a limit to the max number of text in a cell? But im sure that ive done more than this particualr cell that wont wrap before? Thanks Rob -- Rob Gaffney |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text Wrapping
I think the trick is to format the cell as General and not as Text.
Double-click the cell as if to edit (or press F2) after changing the format, and then press Enter to bring about the change. Hope this helps. Pete On Nov 19, 1:04 pm, Gaffnr wrote: This is so basic im embarrassed to ask but ive done this hundreds of times before and no matter what, I cant get it working. Ive a cell with text in it too long for the cell B5. Ive formatted the cell to wrap text and used autofit but its displaying ######################. The text is all there as i can see it in the editing tooblar when i click on the cell. I have other cells where i have the same issue and other cells where the wrapping has worked properly. Its driving me mad. I can only assume there is a limit to the max number of text in a cell? But im sure that ive done more than this particualr cell that wont wrap before? Thanks Rob -- Rob Gaffney |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text Wrapping
Thanks Pete. Made field General and it worked. Top man.
-- Rob Gaffney "Pete_UK" wrote: I think the trick is to format the cell as General and not as Text. Double-click the cell as if to edit (or press F2) after changing the format, and then press Enter to bring about the change. Hope this helps. Pete On Nov 19, 1:04 pm, Gaffnr wrote: This is so basic im embarrassed to ask but ive done this hundreds of times before and no matter what, I cant get it working. Ive a cell with text in it too long for the cell B5. Ive formatted the cell to wrap text and used autofit but its displaying ######################. The text is all there as i can see it in the editing tooblar when i click on the cell. I have other cells where i have the same issue and other cells where the wrapping has worked properly. Its driving me mad. I can only assume there is a limit to the max number of text in a cell? But im sure that ive done more than this particualr cell that wont wrap before? Thanks Rob -- Rob Gaffney |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrapping Text | Excel Discussion (Misc queries) | |||
| text wrapping when text is pasted in excel | Excel Discussion (Misc queries) | |||
| I am using wrap text in excel, so why isn't all my text wrapping? | Excel Discussion (Misc queries) | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| Wrapping Text | Excel Discussion (Misc queries) | |||
Linear Mode
