This appears to be 2 issues so here are 2 solutions.

It appears that the first issue is dealing with what is called scientific notation. Besides converting the cell to text you could add a ' into the result cell. an example would be to place this formula in cell u1 ="'"&a1
the quotes are around the ' so it is " ' " without the spaces. This will show the whole number. If you need to do calculations with it calculate the value in A1 not U1. U1 is just so you can see the number.

Now the 2nd issue could be accomplished by the formula =right(a1,4)
This will take the last 4 characters of a string and display them. so 01234567892013 will show 2013. Again if you need to do calculation on this change the formula to =right(a1,4)+0

Let me know if this makes sense.

Thanks