Problem with cell formatting and underlining

[JonWestcot]

Hi all:

I'm using Excel 2007, SP1. I'm having a problem with cell formatting.
Here's the situation:

Normally, if data are entered into a cell, they will appear past the edge of
the cell as long as there's nothing in that cell. And that's what I want.

However, if I choose to mark the contents of the cell as Underlined,
everything goes wrong. The cell will clip all text that falls outside the
border of the cell.

Does anyone have any idea how to either fix this or get around it? I'd
hoped that SP1 would have solved the problem, but no.

Thanks!

 

[Roger Govier]

Hi Jon

Works fine for me.

this is some long text that overspills the cell

typed into a cell and underlined, shows up just fine.
Are you sure there is not a space or an invisible character in the cell to
the right?
Enter the cell to the right, and press Delete and see what happens

 

[jon.westcot]

Hi Roger:

Thanks for the reply. This abnormal behavior may be due to several
factors. First, the sheet is one that was converted from Lotus 1-2-3.
Second, it's saved in XLS format, not the new Excel 2007 format. I don't
know if either of those would cause the problem or not.

I may just have to live with this. Or see if it happens on another
computer.

Thanks again!

Jon