TO FILL A COLUMN WITH ONLY THE MONTH NAMES...
Remember this will fill the column with TEXT not date information!
The method described by Pere works if you type the month name as a proper
abbreviation or a full month name with the first letter capitalized in your
locale such as:
[Jan]
[Feb]
El dl 12 de 03 de 2018 a les 19:39 +0100, en/na barewillysprl va escriure:
> how to fill a range of cells by a date-type serie?
>
Hi, in 1.12.32, catalan locale:
I type gener enter febrer enter
Results in two cells with the two first names of months, select the two cells.
Now put the pointer in
Hi,Jan and Dec are not dates. Enter complete dates. If you want you can format
them in a way that shows only the month.
The step value is the number of days.
Note that since months have various numbers of days, you may not be happy with
your series in the long run.
Andreas
Sent from my Samsung