| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
# sign appearing in text boxes, Why?
When I have a large text box (10 lines of wrapped text) excel shows a series
of # instead of the data. This only occurs when I am outside the cell, when inside the cell, the text displays correctly. When viewing in Print Preview, the # appear instead of the desired text. Why does excel do this (v2003) and how can I get it to stop? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
# sign appearing in text boxes, Why?
The # symbol indicates that the column is not wide enough to display the
number within the cell. Widen the column to correct. -- Kevin Backmann "Zaphod42b" wrote: When I have a large text box (10 lines of wrapped text) excel shows a series of # instead of the data. This only occurs when I am outside the cell, when inside the cell, the text displays correctly. When viewing in Print Preview, the # appear instead of the desired text. Why does excel do this (v2003) and how can I get it to stop? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
# sign appearing in text boxes, Why?
It sounds like the text is not in a real textbox--just in a cell.
If that's right, try formatting the cell as General (instead of text). If the text is long, you may find that it just "disappears" from the cell after about 1000 characters. You can see more by adding alt-enters (to force a new line within the cell) every 80-100 characters. Zaphod42b wrote: When I have a large text box (10 lines of wrapped text) excel shows a series of # instead of the data. This only occurs when I am outside the cell, when inside the cell, the text displays correctly. When viewing in Print Preview, the # appear instead of the desired text. Why does excel do this (v2003) and how can I get it to stop? Thanks -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
# sign appearing in text boxes, Why?
Thank you, Worked like a charm.
"Dave Peterson" wrote: It sounds like the text is not in a real textbox--just in a cell. If that's right, try formatting the cell as General (instead of text). If the text is long, you may find that it just "disappears" from the cell after about 1000 characters. You can see more by adding alt-enters (to force a new line within the cell) every 80-100 characters. Zaphod42b wrote: When I have a large text box (10 lines of wrapped text) excel shows a series of # instead of the data. This only occurs when I am outside the cell, when inside the cell, the text displays correctly. When viewing in Print Preview, the # appear instead of the desired text. Why does excel do this (v2003) and how can I get it to stop? Thanks -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
# sign appearing in text boxes, Why?
That workes, but takes me out of my page size settings. The next option
worked great, thanks for the help "Kevin B" wrote: The # symbol indicates that the column is not wide enough to display the number within the cell. Widen the column to correct. -- Kevin Backmann "Zaphod42b" wrote: When I have a large text box (10 lines of wrapped text) excel shows a series of # instead of the data. This only occurs when I am outside the cell, when inside the cell, the text displays correctly. When viewing in Print Preview, the # appear instead of the desired text. Why does excel do this (v2003) and how can I get it to stop? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clicking on numbered boxes, plus and minus sign to show and hide d | Excel Discussion (Misc queries) | |||
| Text not appearing as typed in Excel | Excel Discussion (Misc queries) | |||
| Full Text is not appearing in column | Excel Discussion (Misc queries) | |||
| Why is my cell text not appearing? | Excel Discussion (Misc queries) | |||
| AMPERSAND SIGN IS NOT APPEARING IN THE HEADER,? | Excel Discussion (Misc queries) | |||
Linear Mode
