Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In Excel, using line wrap for text, some cells will appear as ######### on
one line. Attempts to correct the problem by re-entering the format (text-line wrap checked-top alignment) do not work. Even copying the style from a "good" wrapped cell does not correct the problem. |
#2
![]() |
|||
|
|||
![]()
If it has to do with column width, double-click on the line between the
column with the ### and the one to right, you 'll expand the column, exposing the full number. EX: cell A1 has ####, so position the cursor between the A and the B column headers, on the line until the cursor turns into a black line with two arrows. Double-click. "RSCoyner" wrote: In Excel, using line wrap for text, some cells will appear as ######### on one line. Attempts to correct the problem by re-entering the format (text-line wrap checked-top alignment) do not work. Even copying the style from a "good" wrapped cell does not correct the problem. |
#3
![]() |
|||
|
|||
![]()
RS
Try formatting the cells as General. Excel has problems with text-formatted cells when it gets above 250 characters or so. Gord Dibben Excel MVP On Wed, 19 Jan 2005 10:13:02 -0800, "RSCoyner" wrote: In Excel, using line wrap for text, some cells will appear as ######### on one line. Attempts to correct the problem by re-entering the format (text-line wrap checked-top alignment) do not work. Even copying the style from a "good" wrapped cell does not correct the problem. |
#4
![]() |
|||
|
|||
![]()
Thank you for your comments. Your solution would work, but I do not want to
expand the columns - I want it to word wrap so that I can see the text without increasing the width. RSC "Abi" wrote: If it has to do with column width, double-click on the line between the column with the ### and the one to right, you 'll expand the column, exposing the full number. EX: cell A1 has ####, so position the cursor between the A and the B column headers, on the line until the cursor turns into a black line with two arrows. Double-click. "RSCoyner" wrote: In Excel, using line wrap for text, some cells will appear as ######### on one line. Attempts to correct the problem by re-entering the format (text-line wrap checked-top alignment) do not work. Even copying the style from a "good" wrapped cell does not correct the problem. |
#5
![]() |
|||
|
|||
![]()
Thank you for your response. I tried using the general format, but it did not
work. If I format the cell using the number format, I can see the text. However, the text is not a number, it is a text! RSC "Gord Dibben" wrote: RS Try formatting the cells as General. Excel has problems with text-formatted cells when it gets above 250 characters or so. Gord Dibben Excel MVP On Wed, 19 Jan 2005 10:13:02 -0800, "RSCoyner" wrote: In Excel, using line wrap for text, some cells will appear as ######### on one line. Attempts to correct the problem by re-entering the format (text-line wrap checked-top alignment) do not work. Even copying the style from a "good" wrapped cell does not correct the problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How can I Excel to re-size when wrapping text in merged cells | 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) | |||
How can I asign a number value to a text line in Excel? | Charts and Charting in Excel |