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

Answer 1 / 4
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
Answer 2 / 4
Sinistrus
 
I tried the plain Text format, memo, and everything that goes with it, but it does the same...
0
Answer 3 / 4
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
Answer 4 / 4
Sinistrus
 
hihi it works thanks ^^
0