Formula to show only first two digits?

Hi all,
I have a list of numbers and want to make a formula to display the first two digits.
For example I am using =LEFT(D4,1+1) on the number 0102 and I get 10
Whatever I do I cannot get it to recognise the 0
Can someone please help
Thanks
legepe

Are you sure it is not just that cell D4 is formatted as something like 0000?

If you select D4 and look in the formula bar, you will see probably 102.

So it is really a 3 digit number...

Maybe you can use: =TEXT(LEFT(D4,IF(LEN(D4)=3,1,2)),"00")

or

=LEFT(TEXT(D4,"0000"),2)

deleted:-------------------