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?

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


"scubadiver" wrote in message
...
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?

No dollar sign

"Gaurav" wrote:

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


"scubadiver" wrote in message
...
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?

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

"scubadiver" wrote in message
...
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?

Go to TOOLSOPTIONSCALCULATION tabcheck AUTOMATIC.

does THAT work?


"scubadiver" wrote in message
...

No dollar sign

"Gaurav" wrote:

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


"scubadiver" wrote in message
...
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?