Delete the last 2 digits

Hi guys

I have a long list of 4 digit numbers:

e.g.

0234
2434
6566
4566
6785

But I only want the first 2 digits (I need the last two digits deleted). I don't want to just divide by 1000 as this will leve me with a decimal. The numbers are in text format as some of them begin with a 0.

So it would be:

02
24
65
45
67

Is there a formula to do this?

Thanks very much

Chris

Thanks

That worked perfectly. Now I have a new problem.

I have two tabs. The first tab includes 8000+ rows with one column. In each cell is the two digit number.

In the other tab is the list of 99 2 digit numbers and in another column is each 2 digit numbers definition.

e.g

01 Agriculture

I need a formula that puts the definition from tab 2 into tab 1.

Is this possible?

Thankyou very much for the advice.

Chris

very much, you've saved me so much time