Quote:
Originally Posted by Pecoflyer
Question 1 :
You can enter A1:A30000 in the Names box, left of the formula bar, to select the range.
Then type the formula in the formula bar, press and hold the Ctrl key, then press Enter.
Question 2 :
You have to enter the entire date (31/12/2013) in the first cell , format as needed, then drag down
|
Qu 1:
I tried A1:A30 in Name box and just type 300 in the formula bar and then Ctrl+Enter. But only A1 is filled with 300.
Qu 2:
Just noticed that in the cell format option for date, only the date formats which are marked with '*' is applicable for auto jumping between months.