Hi All,
I have 3 different input and i need standart 8 digit output. Total digit should be 8 and i should remove last 2 digit and add 1 or 2 (zero) before the number. Can you please help me for formula or any tools can i use?
input | output | |
1234567802 | 12345678 | should remove last 2 digits |
123456702 | 01234567 | should remove last 2 digit and add 0 |
12345602 | 00123456 | should add 00 before number |
Thank you for your help!!