Hash Marks
May 30, 2007I have my columns set at a certain width, the cells set to Wrap Text, the Row set to Autofit YET sometimes when I add text, the hashmarks show up as if the cell isnt formatted correctly and Excel cant show all the text. I can resize the cell, change the text whatever, nothing changes. The only way I can fix this is to cut the text out, open a separate worksheet, paste the text into a cell and copy the whole cell BACK into the original spreadsheet, then I have to reformat the text, whereupon it behaves as it is supposed to.
I read about a similiar problem and the reply was that a macro might be causing the error. This is not the case here. This doesnt happen with any regularity so it is very difficult to figure out.