View original (French)

Differentiation between zero and O writing

gonfle -  
Raymond PENTIER Posted messages 58209 Registration date   Status Contributor Last intervention   -
Hello, I have a problem to solve; I occasionally receive codes that contain both numbers and letters. These handwritten codes do not distinguish between zero and 'o'. I am therefore confused when it comes to entering them into the computer, and this causes errors.
Could someone tell me if there is a standard writing norm?
Thank you. Best regards.
Configuration: Windows Vista Firefox 3.5.7

6 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hi,

    Aside from the font, for me this 0 is zero numeric value and O is the fifteenth letter of the alphabet.

    If the values you normally receive are numeric values, they should logically be on the right side of the cell; if the zero has been replaced by the O, the values will be on the left. It's possible to write a formula with SUBSTITUTE to eventually replace the O with a zero, but the problem is that if you receive text values containing an O, it will inversely be transformed into a zero.

    Give us more explanations about the values you receive and paste some examples of these values in a post.
    --
    A+

    Mike-31

    A period of failure is the perfect time to sow the seeds of knowledge.
    3