Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell data shows as #############
I have a "text" cell that, when content gets to be too long (I assume greater
than 255, or somesuch), all I see is a single row of pound/hash signs, ie: ################################################## ### filling the cell. Is there a way to change the formatting so that this does not occur? Thanks! PatK |
#2
|
|||
|
|||
The repeated # is what Excel uses to show an entry is too large for column
width. There is no alternative If you told us more about the scenario maybe a workaround would be suggested. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "PatK" wrote in message ... I have a "text" cell that, when content gets to be too long (I assume greater than 255, or somesuch), all I see is a single row of pound/hash signs, ie: ################################################## ### filling the cell. Is there a way to change the formatting so that this does not occur? Thanks! PatK |
#3
|
|||
|
|||
Thanks!
Basically, the text field is part of a status update report we happen to use excel to create. Thus, the cell is a freeform text field, that can be quite lengthy (altho we try to limit it somewhat). But in general, that is about it. I am thinking about just changing the status report to MS Word, but I lose some field validation and conditional formatting capability, when I do that. ideas? Workarounds? Thanks again! "Bernard Liengme" wrote: The repeated # is what Excel uses to show an entry is too large for column width. There is no alternative If you told us more about the scenario maybe a workaround would be suggested. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "PatK" wrote in message ... I have a "text" cell that, when content gets to be too long (I assume greater than 255, or somesuch), all I see is a single row of pound/hash signs, ie: ################################################## ### filling the cell. Is there a way to change the formatting so that this does not occur? Thanks! PatK |
#4
|
|||
|
|||
I think I figured this out...I changed the cell format to General, and it now
works. I had it set to "TEXT" before. Thanks!!! "PatK" wrote: Thanks! Basically, the text field is part of a status update report we happen to use excel to create. Thus, the cell is a freeform text field, that can be quite lengthy (altho we try to limit it somewhat). But in general, that is about it. I am thinking about just changing the status report to MS Word, but I lose some field validation and conditional formatting capability, when I do that. ideas? Workarounds? Thanks again! "Bernard Liengme" wrote: The repeated # is what Excel uses to show an entry is too large for column width. There is no alternative If you told us more about the scenario maybe a workaround would be suggested. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "PatK" wrote in message ... I have a "text" cell that, when content gets to be too long (I assume greater than 255, or somesuch), all I see is a single row of pound/hash signs, ie: ################################################## ### filling the cell. Is there a way to change the formatting so that this does not occur? Thanks! PatK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Data From One Worksheet To Be Used In A Cell In A Different Worksheet | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Repeat Cell Data | Excel Worksheet Functions | |||
sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions |