Word Wrap doesn't work, showing ####

[craig.penny]

Hi all,

Sometimes when I enter text into a cell it will appear as

################################

even when there aren't that many characters (~150).

The wrap word is on, it's formatted as text, and I've resized the cell but nothing seems to work. The crazy thing is that on the same sheet, with the same formatting, I have cells with quite a bit more text and it shows up fine. I've searched around but all I can find are instances of a similar thing happening to merged cells but these aren't merged.

Has anyone experienced this?

Any help is greatly appreciated!

Craig

 

[shg]

Try formatting the cell as something other than Text.

 

[craig.penny]

a) It worked and you are awesome!

b) What the hell?

Thanks very much!