View original (French)

Excel: 01 replaced by 1

Solved
Sinistrus -  
 Sinistrus -
Hello,
I would like that when I enter 01 in a cell it is not replaced by 1
07333699
7333699

Do you have a solution please?

Thank you
Configuration: Windows XP Firefox 3.0.3

4 answers

  1.
    ibtor Posted messages 2564 Status Member 283
     
    It’s not in the cell properties, at the numbers level, is it?
    --
    (\__/)
    (='.'=)
    (&_quot;)_(&_quot;)
    Voici Lapin. Copiez et collez Lapin dans votre signature (ainsi que ce texte) pour l'aider à concrétiser sa domination du monde.
    0
  2. Sinistrus
     
    I tried the plain Text format, memo, and everything that goes with it, but it does the same...
    0
  3. wilfried_42 Posted messages 912 Status Contributor 245
     
    Hello

    These are numbers, leading zeros are not taken into account logically.
    To display non-significant zeros, you have to go to the cell format, choose Custom, and enter: 00000000
    as many zeros as you have possible digits.

    Best regards
    Wilfried
    0