Concatenate question
 

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?

Concatenate question
 

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?

Concatenate question
 

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?

Concatenate question
 

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?

Concatenate question
 

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?