On Dec 11, 9:45 pm, Don wrote:
I have concatinated two cells to create a function and I can cut and past
special the values for that function but it is not until I select the cell
contents and press enter that the function works.

example:

A1 has an equal sign
A2 has C1 where C1 has the number 12
on A3 I code =A1&A2 and it shows =C1
I can copy and past special this onto A4 and it shows =C1 but it will not
show the 12 in C1?

thanks

It doesn't work until you click the cell, then press ENTER? Sounds
like you need to go to TOOLS OPTIONS Calculation Tab, and click
AUTOMATIC radio button