| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
A cell displays many ###'s instead of the text data.
Cell is formatted to wrap. Surrounding cells are ok.
How do we display the text? |
|
#2
|
|||
|
|||
|
Expand the column width?
"BelAir" wrote in message ... : Cell is formatted to wrap. Surrounding cells are ok. : : How do we display the text? |
|
#3
|
|||
|
|||
|
BelAir,
This usually means the column isn't wide enough. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "BelAir" wrote in message ... Cell is formatted to wrap. Surrounding cells are ok. How do we display the text? |
|
#4
|
|||
|
|||
|
If widening the column does not help.........
Excel has problems with cells that are formatted as Text when the number of characters reaches 250 or so. Format the cells as General and see if that helps. Gord Dibben Excel MVP On Thu, 20 Jan 2005 08:15:04 -0800, BelAir wrote: Cell is formatted to wrap. Surrounding cells are ok. How do we display the text? |
|
#5
|
|||
|
|||
|
Doesn't it (it does) "come back" at some point Gord?
When testing this, I copied and pasted several times, and the text returned ?!?!?! While the format was *still* Text ! STRANGE ! -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Gord Dibben" <gorddibbATshawDOTca wrote in message ... If widening the column does not help......... Excel has problems with cells that are formatted as Text when the number of characters reaches 250 or so. Format the cells as General and see if that helps. Gord Dibben Excel MVP On Thu, 20 Jan 2005 08:15:04 -0800, BelAir wrote: Cell is formatted to wrap. Surrounding cells are ok. How do we display the text? |
|
#6
|
|||
|
|||
|
Gord' Message was very helpful and worked. THANKS for all of your input.
"RagDyeR" wrote: Doesn't it (it does) "come back" at some point Gord? When testing this, I copied and pasted several times, and the text returned ?!?!?! While the format was *still* Text ! STRANGE ! -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Gord Dibben" <gorddibbATshawDOTca wrote in message ... If widening the column does not help......... Excel has problems with cells that are formatted as Text when the number of characters reaches 250 or so. Format the cells as General and see if that helps. Gord Dibben Excel MVP On Thu, 20 Jan 2005 08:15:04 -0800, BelAir wrote: Cell is formatted to wrap. Surrounding cells are ok. How do we display the text? |
|
#7
|
|||
|
|||
|
Yes RD, it does "come back" after a point.
At 255+ chars the Text-formatted cell produces ############### From my tests it starts showing text again when the number of characters goes over 1024. Gord On Fri, 21 Jan 2005 07:47:06 -0800, "RagDyeR" wrote: Doesn't it (it does) "come back" at some point Gord? When testing this, I copied and pasted several times, and the text returned ?!?!?! While the format was *still* Text ! STRANGE ! |
|
#8
|
|||
|
|||
|
Interesting !
Thanks Gord. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Yes RD, it does "come back" after a point. At 255+ chars the Text-formatted cell produces ############### From my tests it starts showing text again when the number of characters goes over 1024. Gord On Fri, 21 Jan 2005 07:47:06 -0800, "RagDyeR" wrote: Doesn't it (it does) "come back" at some point Gord? When testing this, I copied and pasted several times, and the text returned ?!?!?! While the format was *still* Text ! STRANGE ! |
|
#9
|
|||
|
|||
|
Thanks Gord - I just encountered this problem for the first time. I changed
the format to General and the issue was resolved. "Gord Dibben" wrote: If widening the column does not help......... Excel has problems with cells that are formatted as Text when the number of characters reaches 250 or so. Format the cells as General and see if that helps. Gord Dibben Excel MVP On Thu, 20 Jan 2005 08:15:04 -0800, BelAir wrote: Cell is formatted to wrap. Surrounding cells are ok. How do we display the text? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
A cell displays many ###'s instead of the text data.
Thank you Thank you Thank you! I've been battling with this problem forever.
You'd think this w/b included in Help for Excel--it's a pretty basic problem. "Gord Dibben" wrote: If widening the column does not help......... Excel has problems with cells that are formatted as Text when the number of characters reaches 250 or so. Format the cells as General and see if that helps. Gord Dibben Excel MVP On Thu, 20 Jan 2005 08:15:04 -0800, BelAir wrote: Cell is formatted to wrap. Surrounding cells are ok. How do we display the text? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Hide text that doesn't fit in the cell | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Linear Mode
