Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
words in cell change to pound signs
When I go to the next cell to type in text, the words in the cell I just
finished typing turn into ############. I have to double click to turn them back into words, but they go right back to ########## when I go to another cell. I have the cell formatted for text and wrap text. Does anyone know what to do to fix this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
words in cell change to pound signs
Change the formatting of the cell to General.
Excel has a problem with a text-formatted cell when number of characters are between 255 and 1024. If entering numbers or dates, widen the column. Gord Dibben MS Excel MVP On Sat, 6 Dec 2008 20:04:01 -0800, Marsha wrote: When I go to the next cell to type in text, the words in the cell I just finished typing turn into ############. I have to double click to turn them back into words, but they go right back to ########## when I go to another cell. I have the cell formatted for text and wrap text. Does anyone know what to do to fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does my text appear as pound signs | Excel Discussion (Misc queries) | |||
why do I get a series of pound signs in a cell? | 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) |