View original (French)

Show non-printable characters in EXCEL

Eurlzoo -  
 eurlzoo -
Hello,

I would like to display the carriage return in my formulas, the little square, but I can't manage to do it. It seems to me that it used to happen automatically if "wrap text" was not checked, but I can't get it back.
I'm using Excel 2007.

Thank you in advance.

Configuration: Windows 7 / Internet Explorer 8.0

3 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,

    ???
    The small square appears with "Alt+Enter" when you want to go to the next line
    --
    Michel
    0
  2. eurlzoo
     
    Indeed, that's the problem; it's present but not displaying.
    I can verify it by checking "automatic line break" because the text does return to the line where I used "ALT ENTER," but when I uncheck it, the text is just glued together like a CONCATENATE without little squares in between to symbolize the line break.
    0
  3. eurlzoo
     
    After several searches around me, it seems to me that this comes from Windows 7. The only Excel where I can see the symbols runs on XP, and we are all on Excel 2007.
    0