deleting the first 2 digits of number in a cell

[NoviceMALGER]

I need a formula that will truncate the first two digits of a value in
another column. For example. I want 10123 in column A to be 123 in column C.

 

[Rick Rothstein]

Try this formula...

=MID(A1,3,99)

The 99 just needs to be a number equal to or larger then the maximum length
of A1 minus 3.

By the way, if the values you want are **always** the last 3 characters, a
simpler formula to try is this...

=RIGHT(A1,3)

 

[Pete_UK]

You could use this formula:

=MOD(A1,1000)

and copy down as required.

Hope this helps.

Pete