How to remove the first 3 numbers from a cell

For doing this select the range, It should be single column range.

Go to Data/Text to columns/'check' Fixed Width/now from the scale click on 3rd character point/one line will be inserted/click next/'check' Do not import column/Finish

It will remove first 3 numbers from the selected range.

you can use formula as well C2=RIGHT(B2,LEN(B2)-3)

How can I remove the first 3 numbers from a cell and leave the rest eg 000123, I just want 123 left in the cell

Are the first 3 numbers always leading zeroes? If so, you can do this without a formula (this will change the values in place rather than use up additional cells to hold the formulas). Select the cell, or column of cells if more than one, and change the Cell Format for the selection to "General", then press ALT+de and, as soon as the dialog box appears, click the Finish button.

On the other hand, if you are looking for a formula solution, you might consider this one...

=REPLACE(A1,1,3,"")

How can I remove the first 3 numbers from a cell and leave the rest eg 000123, I just want 123 left in the cell

Are the first 3 numbers always leading zeroes? If so, you can do this without a formula (this will change the values in place rather than use up additional cells to hold the formulas). Select the cell, or column of cells if more than one, and change the Cell Format for the selection to "General", then press ALT+de and, as soon as the dialog box appears, click the Finish button.