I have free text fields in a spreadsheet I developed so co-workers can
provide status updates on their work. Occasionally, when someone types in a
status update, the cell only displays pound signs (################). If I
select that cell, the text appears in the formula bar, but the active cell
just shows pound signs. It doesn't seem to be related to the amount of text
that was typed, because other text entries are longer but they display just
fine in the cell. How do I fix this? Thank you.

If there is nothing in the cell to the right it will usually run on across,
if you want to only display within the cell text is entered and get the pound
signs it is usually because the column is to narrow, just widen it and you
can see all the text.

Mike Rogers

"r1971" wrote:

I have free text fields in a spreadsheet I developed so co-workers can
provide status updates on their work. Occasionally, when someone types in a
status update, the cell only displays pound signs (################). If I
select that cell, the text appears in the formula bar, but the active cell
just shows pound signs. It doesn't seem to be related to the amount of text
that was typed, because other text entries are longer but they display just
fine in the cell. How do I fix this? Thank you.

Thanks for the reply, but I have "Word Wrap" activated. So that should
alleviate that problem. However, I did go ahead and widen the column to the
width of my monitor to see what would happen...no luck!

"Mike Rogers" wrote:

If there is nothing in the cell to the right it will usually run on across,
if you want to only display within the cell text is entered and get the pound
signs it is usually because the column is to narrow, just widen it and you
can see all the text.

Mike Rogers

"r1971" wrote:

I have free text fields in a spreadsheet I developed so co-workers can
provide status updates on their work. Occasionally, when someone types in a
status update, the cell only displays pound signs (################). If I
select that cell, the text appears in the formula bar, but the active cell
just shows pound signs. It doesn't seem to be related to the amount of text
that was typed, because other text entries are longer but they display just
fine in the cell. How do I fix this? Thank you.

Just out of curiosity - what happens when you change the number format - if
that cell - to "General" !?
Micky


"r1971" wrote:

Thanks for the reply, but I have "Word Wrap" activated. So that should
alleviate that problem. However, I did go ahead and widen the column to the
width of my monitor to see what would happen...no luck!

"Mike Rogers" wrote:

If there is nothing in the cell to the right it will usually run on across,
if you want to only display within the cell text is entered and get the pound
signs it is usually because the column is to narrow, just widen it and you
can see all the text.

Mike Rogers

"r1971" wrote:

I have free text fields in a spreadsheet I developed so co-workers can
provide status updates on their work. Occasionally, when someone types in a
status update, the cell only displays pound signs (################). If I
select that cell, the text appears in the formula bar, but the active cell
just shows pound signs. It doesn't seem to be related to the amount of text
that was typed, because other text entries are longer but they display just
fine in the cell. How do I fix this? Thank you.

Excel has a problem with cells formatted as text where the value is between 255
and 1024 characters long. Formatting as General will fix the display.

r1971 wrote:

I have free text fields in a spreadsheet I developed so co-workers can
provide status updates on their work. Occasionally, when someone types in a
status update, the cell only displays pound signs (################). If I
select that cell, the text appears in the formula bar, but the active cell
just shows pound signs. It doesn't seem to be related to the amount of text
that was typed, because other text entries are longer but they display just
fine in the cell. How do I fix this? Thank you.

--

Dave Peterson

That did it...thank you!

"מיכ�ל (מיקי) �בידן" wrote:

Just out of curiosity - what happens when you change the number format - if
that cell - to "General" !?
Micky


"r1971" wrote:

Thanks for the reply, but I have "Word Wrap" activated. So that should
alleviate that problem. However, I did go ahead and widen the column to the
width of my monitor to see what would happen...no luck!

"Mike Rogers" wrote:

If there is nothing in the cell to the right it will usually run on across,
if you want to only display within the cell text is entered and get the pound
signs it is usually because the column is to narrow, just widen it and you
can see all the text.

Mike Rogers

"r1971" wrote:

I have free text fields in a spreadsheet I developed so co-workers can
provide status updates on their work. Occasionally, when someone types in a
status update, the cell only displays pound signs (################). If I
select that cell, the text appears in the formula bar, but the active cell
just shows pound signs. It doesn't seem to be related to the amount of text
that was typed, because other text entries are longer but they display just
fine in the cell. How do I fix this? Thank you.

That did it...thank you!!

"Dave Peterson" wrote:

Excel has a problem with cells formatted as text where the value is between 255
and 1024 characters long. Formatting as General will fix the display.

r1971 wrote:

I have free text fields in a spreadsheet I developed so co-workers can
provide status updates on their work. Occasionally, when someone types in a
status update, the cell only displays pound signs (################). If I
select that cell, the text appears in the formula bar, but the active cell
just shows pound signs. It doesn't seem to be related to the amount of text
that was typed, because other text entries are longer but they display just
fine in the cell. How do I fix this? Thank you.

--

Dave Peterson
.