Date in text formatting

Hi everybody,
hi create a text colum where i want to have a date in letters (es. march 2024)
My initial value expression is 

CONCATENATE(INDEX(
LIST(
"Gen", "Feb", "Mar", "Apr", "Mag", "Giu",
"Lug", "Ago", "Set", "Ott", "Nov", "Dic"
),
MONTH(TODAY())
), " ", YEAR(TODAY()))

the expression it's true and in my google sheets return value mar 2024, but in the app value is 45352

i also tried creating a virtual column 
TEXT([Month]) but result it's the same?

Where am i wrong

thank you in advantage




Solved Solved
0 1 76
1 ACCEPTED SOLUTION

By any chance, your column type in your gSheet is set as number or automatic. Change it to "Plain text" and see if that solves the challenge.

View solution in original post

1 REPLY 1

By any chance, your column type in your gSheet is set as number or automatic. Change it to "Plain text" and see if that solves the challenge.

Top Labels in this Space