Tripleseas
Board Regular
- Joined
- Jul 12, 2022
- Messages
- 87
- Office Version
- 2013
- Platform
- Windows
Hello,
i want a formula that can add leading zero after a serie of number in excel. the maximum to fill is 7 digits as shown below : thank
i want a formula that can add leading zero after a serie of number in excel. the maximum to fill is 7 digits as shown below : thank
Classeur3 | ||||
---|---|---|---|---|
A | B | |||
1 | number | Number edited | ||
2 | 315 | 315 000 | ||
3 | 312 | 312 000 | ||
4 | 435 | 435 000 | ||
5 | 536 | |||
6 | 634 | |||
7 | 1 179 | 1 179 000 | ||
8 | 444 | |||
9 | 510 | |||
10 | 133 | |||
11 | 424 | |||
12 | 692 | |||
13 | 517 | |||
14 | 1 318 | |||
15 | 1 269 | |||
16 | 378 | |||
17 | 155 | |||
18 | 176 | |||
19 | 429 | |||
20 | 502 | |||
21 | 702 | |||
22 | 551 | |||
23 | 238 | |||
24 | 1 070 | |||
Feuil1 |