Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A lot of #'s in my text-formatted cell...
I want to organize some information in an Excel spreadsheet. In one of the
columns, I want to make notes about a given line of data. I've selected that column as "Text" and chosen the "Wrap text" option. For a couple of lines, it works. But for 3 or more, I just get the ##### signs. I'd like to be able to read my notes as I scroll down. Anyway to resize or reset things so that the cell will show as much text as I type into it? Thanks. ddc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
A lot of #'s in my text-formatted cell...
Hi,
Normally Excel only displays #'s in cells whose column width is too narrow, and only for cells containing numbers or negative dates (which still are numbers). Please show us an example of the text that is in the cell the display's #'s Also what version of Excel are you using? What happens when you widen the column? Does the problem go away or just continue? Also you said the first couple of lines are ok and then the problem begins. Do you mean that you see a cell that is wrapped and the first lines of that cell are visible and ok and then right in the middle of the cell you begin getting #####? -- Thanks, Shane Devenshire "DeeDeeCee" wrote: I want to organize some information in an Excel spreadsheet. In one of the columns, I want to make notes about a given line of data. I've selected that column as "Text" and chosen the "Wrap text" option. For a couple of lines, it works. But for 3 or more, I just get the ##### signs. I'd like to be able to read my notes as I scroll down. Anyway to resize or reset things so that the cell will show as much text as I type into it? Thanks. ddc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
A lot of #'s in my text-formatted cell...
Excel has trouble with cells formatted as text where the contents are between
255 and 1024 characters. Try formatting your cell as General (or anything but text) and the ##'s should go away. DeeDeeCee wrote: I want to organize some information in an Excel spreadsheet. In one of the columns, I want to make notes about a given line of data. I've selected that column as "Text" and chosen the "Wrap text" option. For a couple of lines, it works. But for 3 or more, I just get the ##### signs. I'd like to be able to read my notes as I scroll down. Anyway to resize or reset things so that the cell will show as much text as I type into it? Thanks. ddc -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REPLACE PART OF CELL WITH FORMATTED TEXT | Excel Worksheet Functions | |||
Formula fails in text formatted cell | Excel Worksheet Functions | |||
Formatted Cell Changes Format When Text Is Entered | Setting up and Configuration of Excel | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
How to make a cell return the formatted value in a text string (i. | Excel Worksheet Functions |