How to Eliminate the first 2 digit out of 10 digit number

W

wliong

Hi all,
I'm trying to eliminate the first 2 digit from 10 digit number. For
example: if the number is *0001234567*, then I want to delete the first
2 zeros and thus it becomes *01235467*. Is there any way to do that?

Thank you very much
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display entire number in cell 3
Conversion of 10 digit number into xx-xxx-xx-xxx 4
VBa Write integer to file 0
Combobox filtering 2
Convert 2-digit year 3
how to check if a number has no more than 2 decimal digits 12
Removing last 2 digits on a number in Excel 3
Check Digit:- A Real Challenge! 12

Top