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?