View original (French)

O with a horizontal bar

Solved
JCB40 Posted messages 3060 Registration date   Status Member Last intervention   -  
JCB40 Posted messages 3060 Registration date   Status Member Last intervention   -
Hello,
I would like to know if it is possible to create a horizontally crossed O in Excel.
Thank you for your help.
Best regards

Configuration: Windows / Firefox 69.0

3 answers

  1.
    baladur13 Posted messages 47327 Registration date   Status Moderator Last intervention   14 390
     
    Hello,
    In the character table by doing "Insert" - "Special Characters"
    it's at the bottom of the tables

    --
    Very difficult to catch a black cat in a dark room.
    Especially when it isn’t there...
    1
  2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    if you want an occasional 0 under certain conditions, you can use conditional formatting with font style and check "strikethrough"
    for example, to have a strikethrough 0 in B1 if A1=1 and B1=0:
    conditional formatting formula:
    =AND(A1=1,B1=0)
    and format: font / strikethrough
    and in any case, a strikethrough font cell format will give you a strikethrough display
    best regards

    --
    The quality of the answer mainly depends on the clarity of the question, thank you!
    1
  3. JCB40 Posted messages 3060 Registration date   Status Member Last intervention   479
     
    Hello

    Thank you both for your solutions.
    Best regards
    0