@שואף-לדעת
יש לי קוד שאני משתמש בו, לא זוכר את המקור, ולא בטוח שעובד בכל גרסאות האופיס, תנסה. הוא מקבל את התאריך מ-B3
=CONCATENATE(CHOOSE(LEFT(TEXT(B3,"[$-he-IL,8]dd mmmm yyyy;@"),2),"א","ב","ג","ד","ה","ו","ז","ח","ט","י","יא","יב","יג","יד","טו","טז","יז","יח","יט","כ","כא","כב","כג","כד","כה","כו","כז","כח","כט","ל"),MID(TEXT(B3,"[$-he-IL,8]dd mmmm yyyy;@"),3,LEN(TEXT(B3,"[$-he-IL,8]dd mmmm yyyy;@"))-6),IFERROR(CHOOSE(MID(TEXT(B3,"[$-he-IL,8]dd mmmm yyyy;@"),LEN(TEXT(B3,"[$-he-IL,8]dd mmmm yyyy;@"))-2,1),"ק","ר","ש","ת","תק","תר","תש","תת","תתר"),""),IFERROR(CHOOSE(MID(TEXT(B3,"[$-he-IL,8]dd mmmm yyyy;@"),LEN(TEXT(B3,"[$-he-IL,8]dd mmmm yyyy;@"))-1,1),"י","כ","ל","מ","נ","ס","ע","פ","צ"),""),IFERROR(CHOOSE(MID(TEXT(B3,"[$-he-IL,8]dd mmmm yyyy;@"),LEN(TEXT(B3,"[$-he-IL,8]dd mmmm yyyy;@"))-0,1),"א","ב","ג","ד","ה","ו","ז","ח","ט","י"),""))