Alt+Enter works in the formula bar, but not in the cell
 

Hello!

I have read through questions on fitting a lot of text into a cell, and the
answer that would seem to work would be to click on the cell with the text,
put cursor up into the formula bar where the cell's text is displayed, then
press Alt-Enter every 50 characters or so. The text in the cells are all
about 400 characters.

When I use the Alt+Enter, all that happens is that the lines break
appropriately in the formula bar, but the cell still displays only ####.

The Alt key works for all the menus (Edit, Insert, etc.).
The font size is 9pt.
Is there something I'm missing?

Any help would be TREMENDOUSLY appreciated.

Many many, many many, and many more, thanks,

Elessvie

Alt+Enter works in the formula bar, but not in the cell
 

Try changing the cell's format from Text to General.



Elessvie wrote:

Hello!

I have read through questions on fitting a lot of text into a cell, and the
answer that would seem to work would be to click on the cell with the text,
put cursor up into the formula bar where the cell's text is displayed, then
press Alt-Enter every 50 characters or so. The text in the cells are all
about 400 characters.

When I use the Alt+Enter, all that happens is that the lines break
appropriately in the formula bar, but the cell still displays only ####.

The Alt key works for all the menus (Edit, Insert, etc.).
The font size is 9pt.
Is there something I'm missing?

Any help would be TREMENDOUSLY appreciated.

Many many, many many, and many more, thanks,

Elessvie

--

Dave Peterson

Alt+Enter works in the formula bar, but not in the cell
 

Make sure the cell does not have the Text number format. Switch to General.
(Format, Cells, Number, General).

--
Jim
"Elessvie" wrote in message
...
Hello!

I have read through questions on fitting a lot of text into a cell, and
the
answer that would seem to work would be to click on the cell with the
text,
put cursor up into the formula bar where the cell's text is displayed,
then
press Alt-Enter every 50 characters or so. The text in the cells are all
about 400 characters.

When I use the Alt+Enter, all that happens is that the lines break
appropriately in the formula bar, but the cell still displays only ####.

The Alt key works for all the menus (Edit, Insert, etc.).
The font size is 9pt.
Is there something I'm missing?

Any help would be TREMENDOUSLY appreciated.

Many many, many many, and many more, thanks,

Elessvie

Alt+Enter works in the formula bar, but not in the cell
 

That did the trick. Thank you so much!

"Dave Peterson" wrote:

Try changing the cell's format from Text to General.



Elessvie wrote:

Hello!

I have read through questions on fitting a lot of text into a cell, and the
answer that would seem to work would be to click on the cell with the text,
put cursor up into the formula bar where the cell's text is displayed, then
press Alt-Enter every 50 characters or so. The text in the cells are all
about 400 characters.

When I use the Alt+Enter, all that happens is that the lines break
appropriately in the formula bar, but the cell still displays only ####.

The Alt key works for all the menus (Edit, Insert, etc.).
The font size is 9pt.
Is there something I'm missing?

Any help would be TREMENDOUSLY appreciated.

Many many, many many, and many more, thanks,

Elessvie

--

Dave Peterson