Displaying Text

[AZULA]

Hi everyone,
When I use the formula: ="The date is" & TEXT(M30, "dddd, mmmm yyyy") I encounter with this: The date is00, mmmm 2020
Although the M30 cell is in the date format, the formula did not work the way I wanted it to. I could not understand what happened? Any advice or suggestions very welcome!

 

[RoryA]

It sounds like your regional settings don't use dd and mm for day and month. If you format a cell the way you want, then in the Format cells dialog select the Custom option, what format is shown there?