You are viewing a single comment's thread from:
RE: Not the most productive day in my life! (Fooling around with excel)
Yep, tried it.
The date in the bet tab is manually entered. The format is choosen by the field properties date.
Than this is split up in to 3 fields. For the year (out the top of my head) is tekst(cell;”jjjj”). But this fails when I do open it on the home laptop which is an American version.
Here it does expect “yyyy”.
Did try a lot already. Guess I will have to use my old VBA skills 😔
I think the function =rechts(A5;4) could do the job. Did you try that one?