Writing a formular on taking first four numbers of another field


Sorry for the novice question but i was wondering on how to take the first four numbers from a field of numbers itself. I did try the LEFT formula but it doesnt seem to work for me.

Now, there is a field called Ticket with a string of about 10 numbers with the first four numbers being the year. I want to take those four numbers from that field and put them in another field.


In order to do that, you first need to ensure your field is defined as text (A) and not a number (#). That should be all.