Concatenate question

[scubadiver]

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?

 

[Gaurav]

Does your formula have $ signs in it? If yes, remove them.

 

[scubadiver]

No dollar sign

Does your formula have $ signs in it? If yes, remove them.

 

[David Biddulph]

Tools/ Options/ Calculation:
You need Automatic, not Manual.

 

[Gaurav]

Go to TOOLS>OPTIONS>CALCULATION tab>check AUTOMATIC.

does THAT work?