I am making a newsletter and the date format has no option of simply Month and Year. For example, if I want the newsletter for Oct-Nov 2018, it is not in the formatting choices given. Any ideas on how to change it?
MacBook Air
Hi 'dude,
(Constructed in Numbers, but behaviour is essentially the same in Pages.)
Date formats apply only to the date part of date and time values. Date and Time values specify a single instant in time, and can be formatted to show only the date part,
All of the filled cells in this table contain the formula TODAY(), which returns a Date and Time value for today's date at the time 00:00:00 (midnight, at the beginning of the day.)
All but the last are formatted to show only the Date part, with the elements arranged in the order shown, and formatted as shown.
The bottom cell contains the same value, to which a Custom format has been applied. The format shows only the monthname (short form) and the year (including the century digits).
To show a range of dates (as you wish to do), you'll need to enter the value as TEXT. the easiest way to do that is to start with an apostrophe, which signals numbers that what follows is text, not a number or a date. Numbers then displays the entry as it was entered, omitting the ' at the beginning.
Same table, with a row added to accomodate entry of your example, entered as described here:
Formatting on the cell was automatically changed from Custom to Text by Numbers, as evidenced by the default text alignment to the left edge of the cell. (This behaviour also applies in Pages tables.)
As the cell's data is text, it can't be used as a date in formulas.
Regards,
Barry
Hi 'dude,
(Constructed in Numbers, but behaviour is essentially the same in Pages.)
Date formats apply only to the date part of date and time values. Date and Time values specify a single instant in time, and can be formatted to show only the date part,
All of the filled cells in this table contain the formula TODAY(), which returns a Date and Time value for today's date at the time 00:00:00 (midnight, at the beginning of the day.)
All but the last are formatted to show only the Date part, with the elements arranged in the order shown, and formatted as shown.
The bottom cell contains the same value, to which a Custom format has been applied. The format shows only the monthname (short form) and the year (including the century digits).
To show a range of dates (as you wish to do), you'll need to enter the value as TEXT. the easiest way to do that is to start with an apostrophe, which signals numbers that what follows is text, not a number or a date. Numbers then displays the entry as it was entered, omitting the ' at the beginning.
Same table, with a row added to accomodate entry of your example, entered as described here:
Formatting on the cell was automatically changed from Custom to Text by Numbers, as evidenced by the default text alignment to the left edge of the cell. (This behaviour also applies in Pages tables.)
As the cell's data is text, it can't be used as a date in formulas.
Regards,
Barry
No date format that I know spans months or years or anything. It is always the exact date as set in System Preferences.
Just type it.
I am curious why you want to spend so much time on something that is a one off simple update every 2 months that takes seconds?
Make the Date Placeholder text, then click once on it and type the change.
I'm sure there are far more pressing things you can do to streamline your newsletter production.
Exactly what i was looking for. Thank you. It bothered me that I could not do this through any option before. Thanks again!!
How to change the date format in Pages?
