Excel - cell text too long displays as hashes

J

Julie

I have exported TFS work items into Excel. This includes text that are very
long, and spanning over multiple lines. Whenever I click this cell. The
contents revert to hashes, making it very difficult to work with (or print)
work items in Excel.

I have tried formating the cell to custom format, but clicking in the cell
losing this formating.

Is there any way to remove the hashes?
 
P

Pete_UK

Ensure that the cell is formatted as General rather than Text, and
once you have changed the format then click in that cell again, press
F2 and then <enter> to ensure that the format change takes effect.

Hope this helps.

Pete
 
Top