Writing a formular on taking first four numbers of another field

[Ahmed_Iyadh]

Hello,

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.

[FredK_Trashmail]

Hey,

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.

Cheers

Fred