I entered date in my google spreadsheet example 25/10/2022, then I want to use fill handle to copy that date in the column but the date automatically increasing , like 26/10/2022, 27/10/2022. and i don't need that.

I was expecting to copy same date in the column

CodePudding user response：

try:

="25/10/2022"

or lock it down like:

=$A$1