Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do I get a series of pound signs in a cell?
The cell was filled with text that I want to keep. Then I copy / paste in
additional text, and all text turns to pound signs (#). Symbols go left to right in a straight line and do not text wrap at all. Why is this happening? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do I get a series of pound signs in a cell?
Try changing the format of the cell from text to General.
Mark S. wrote: The cell was filled with text that I want to keep. Then I copy / paste in additional text, and all text turns to pound signs (#). Symbols go left to right in a straight line and do not text wrap at all. Why is this happening? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do I get a series of pound signs in a cell?
On Jul 15, 4:38*pm, Dave Peterson wrote:
Try changing the format of the cell from text to General. Mark S. wrote: The cell was filled with text that I want to keep. Then I copy / paste in additional text, and all text turns to pound signs (#). Symbols go left to right in a straight line and do not text wrap at all. Why is this happening? -- Dave Peterson When you copy / Paste the target cell takes on the format of the copied cell, including erasing your conditiona lformat.. Sop changing the format to General won't solve the problem. Instead use Paste- special values. ed |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do I get a series of pound signs in a cell?
On Jul 15, 4:38*pm, Dave Peterson wrote:
Try changing the format of the cell from text to General. Mark S. wrote: The cell was filled with text that I want to keep. Then I copy / paste in additional text, and all text turns to pound signs (#). Symbols go left to right in a straight line and do not text wrap at all. Why is this happening? -- Dave Peterson As an afterthought: How can you copy / paste text to a cell with text in it? You would erase the original text as well as the formatting. If you copied it off the formula bar and pasted it editorially in the target cell's formula bar it won't change the formatting. Just what are you doing? ed |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do I get a series of pound signs in a cell?
The text is too wide to display. Expand the column size or allow the cell to
wrap text. -- HTH... Jim Thomlinson "Mark S." wrote: The cell was filled with text that I want to keep. Then I copy / paste in additional text, and all text turns to pound signs (#). Symbols go left to right in a straight line and do not text wrap at all. Why is this happening? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do I get a series of pound signs in a cell?
If the OP is pasting additional text, it doesn't sound like a Copy|paste problem
to me. It sounds like the OP is already pasting that additional text into the existing text in the cell--either in the formula bar or directly in the cell (if that option is turned on). ed wrote: On Jul 15, 4:38 pm, Dave Peterson wrote: Try changing the format of the cell from text to General. Mark S. wrote: The cell was filled with text that I want to keep. Then I copy / paste in additional text, and all text turns to pound signs (#). Symbols go left to right in a straight line and do not text wrap at all. Why is this happening? -- Dave Peterson When you copy / Paste the target cell takes on the format of the copied cell, including erasing your conditiona lformat.. Sop changing the format to General won't solve the problem. Instead use Paste- special values. ed -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do I get a series of pound signs in a cell?
Jim
Text being too long will not give you ## signs on a narrow column. Numbers will give you ## signs if the column is not wide enough. Dave is right.......Excel has a problem with text-formatted cells when the character count is between 255 and 1024. Changing to General format will get rid of the ## signs. Gord Dibben MS Excel MVP On Tue, 15 Jul 2008 20:38:45 -0700, Jim Thomlinson wrote: The text is too wide to display. Expand the column size or allow the cell to wrap text. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does my text appear as pound signs | Excel Discussion (Misc queries) | |||
pound signs | Excel Discussion (Misc queries) | |||
Pound Signs...Yikes! | Excel Discussion (Misc queries) | |||
pound signs cell formatting | Excel Discussion (Misc queries) | |||
Pound (#) signs instead of text | Excel Discussion (Misc queries) |