deleting the first 2 digits of number in a cell
 

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.

deleting the first 2 digits of number in a cell
 

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)

--
Rick (MVP - Excel)


"NoviceMALGER" wrote in message
...
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.

deleting the first 2 digits of number in a cell
 

You could use this formula:

=MOD(A1,1000)

and copy down as required.

Hope this helps.

Pete

"NoviceMALGER" wrote in message
...
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.