dates in excel

I want it to be 12 December 2019 not 12/12/19

Please note that this is a LibreOffice site not Microsoft. LO spreadsheet is Calc.

Hello,

format cell using format code D MMMM YYYY (On cell Right click -> Format Cells -> Tab: Numbers -> Category: Date and change the field below Format code to contain the code above).

You may also be interested in Number Format Codes general information

Hope that helps.

Thanks easy when you know how.

Hello - If the answer is correct or helped you to solve your problem, please click the check mark (:heavy_check_mark:) next to the answer.