Differentiation between zero and O writing
gonfle
-
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur 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.
Could someone tell me if there is a standard writing norm?
Thank you. Best regards.
Configuration: Windows Vista Firefox 3.5.7
6 réponses
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.
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.
