Excel - cell text too long displays as hashes

  • Thread starter Thread starter Julie
  • Start date Start date
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?
 
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
 
Back
Top