muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hello all,
i have a problem to adding/insert zero number with multiple condition for this which total character number is 12
<tbody>
</tbody>
it's possible with excel formula to figure out?
thanks for your helping...
m.susanto
i have a problem to adding/insert zero number with multiple condition for this which total character number is 12
sample data (excel format general) | after formula |
2005-6-12 | 200506000012 |
1997-11-7 | 199711000007 |
2001-10-358 | 200110000358 |
1985-5-4521 | 198505004521 |
2002-12-8 | 200212000008 |
etc... |
<tbody>
</tbody>
it's possible with excel formula to figure out?
thanks for your helping...
m.susanto