And I have no idea how to do this. I just want it to say “February 8”.
I also really dislike having to create an account with an email to ask one question. I’ve had my information released several times by companies not securing their databases so I really don’t like having to give out this information to ask one question.
I also really dislike having to create an account with an email to ask one question
…and frequent users answering on this site would dislike the spam avalanche, which would overrun this site, if there wouldn’t be a minimal barrier to protect from this to happen.
Please, in future give more detail in your question and less irrelevant stuff
If you live in USA and LO does dates in a format that you are not familiar with, then you need to make sure the settings in LO are correct.
Click Tools > Options > Language Settings > Languages, under Language of User interface you should have English (USA) selected, under Locale setting you should English (USA) selected, under Date acceptance you should see M/D/Y;M/D
On to your question
You have put common in the tags but I assume you mean that you want to insert the date in a Writer template.
Click in your document where you want the date.
In the menu click Insert > Field > More Fields (or Ctrl+F2), select tab Document, under Type click Date, under Select click Date (Fixed) {the date when a document is created from the template}, under Format click Additional Formats.
In the dialog that opens select everything in Format Code and delete it. In its place type MMMM D (or MMMM, D as in your title). Click OK, click Insert and then close Fields dialog box.
Calc
If you want the date in a Calc cell then click the cell in which you want the date. Press Ctrl+; which will enter today’s date. Right-click on the cell and select Format Cell. In the dialog that opens click the tab Numbers. Date will already be selected so select everything in Format Code and delete it. In its place type MMMM D.
2nd Edit Tue 9 Feb 04:45 UTC following comment details
US date format is MDY, UK date format is DMY.
Double-click on cell to enter, then Insert > Field > Date will work. It will enter only the file date as a field.
I think you want the cells to show January 7, etc. instead of 2021-01-07:
Select the cells, right-click on the cells and select Format Cell.
In the dialog that opens click the tab Numbers. Date will already be selected so select everything in Format Code and delete it. In its place type MMMM D and click OK
Hello,
I’m not sure why being Canadian or American or UK would affect that. My location is Canada and that is correct in the language settings. I’m using a MacBook if it’s different between operating systems. (No other program that I’ve used is different between OS’s.)
If I select the cell and go to Insert > Field > More Fields it is greyed out.
I want the fields to show January 7, January 15, January 24 and February 3. It’s frustrating this is so difficult to change.
This message board is confusing and will not let me add photos. I have posted another comment with photos attached.
You confuse the phrases “fields” and “cells” - You don’t want to change a field’s format and you don’t want to insert a field but you want to change a cell’s format. A “field” is a quite different thing (in Calc mainly used in footers/headers or in forms). You need to use menu Format -> Cells.
Hello,
I’m not sure why being Canadian or American or UK would affect that. My location is Canada and that is correct in the language settings. I’m using a MacBook if it’s different between operating systems. (No other program that I’ve used is different between OS’s.)
If I select the cell and go to Insert > Field > More Fields it is greyed out.
I want the fields to show January 7, January 15, January 24 and February 3. It’s frustrating this is so difficult to change.
I want the fields to show January 7,
You confuse the phrases “fields” and “cells” - You don’t want to change a field’s format but a cell’s format since your screenshot shows cells and not fields. A “field” is a quite different thing. You need to use menu Format -> Cells.
