copying the same date in 100 cells in the same column

[lezawang]

Hi
How to fill a column (let say 100 cells) with the same date? I typed A1=28/09/2018 and then auto fill but excel added 1 day to each cell. I tried to Right click auto fill --> series and then the End date 28/09/2018 but nothing get filled. The only way I see if i type in A1= today() and then auto fill A1. Is there any other way?

 

[Michael M]

Highlight A1 to A100
type the formula in once, then press CTRL + Enter