As an example, in A2 I have the number 56 and I have other numbers below it
in a column. I would use the following

=concatenate("'",A2,"',")

to create

'56',

but if I copy the formula down the column, the cell remain as

'56',

rather than changing to what is in the reference cell. Is this because the
reference cells are formatted wrongly?