eliminate first two digits of number...

[RTE]

I'm trying to figure out a way to eliminate the first two digits of a column of numbers. In the numbers below I would like to delete/eliminate the "99" prefix of the three numbers.

Any help would be great. Thanks.

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl22 height=17 width=64 align=right x:num>99108</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl22 height=17 align=right x:num>99210</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl22 height=17 align=right x:num>99244</TD></TR></TBODY></TABLE>

 

[njimack]

Select the column, go to Data>Text to Columns>Fixed Width. Create a break point after the 1st 2 digits, press Next, choose Do not import column

 

[Robert Mika]

Or formula:
=RIGHT(A1,LEN(A1)-2)

 

[Maheshp]

Try :

'=MID(A1,3,LEN(A1))
'=RIGHT(A2,LEN(A2)-2)

 

[mikerickson]

Perhaps =MOD(A1,1000)