Text function to pull true value

[Piers 2k]

Hi folks,

Cell contents are something like =March!$C$7, and this calculates correctly.
I need to have a formula in a nearby cell to return the contents of this
cell (a string), not the calculated value. I want to SEE the formula.

Preferably I need to use built in functions, since this will be a new file
most times it's used.

I can do this in VBA, but is there anything built in?

TIA,

Piers

 

[Pete_UK]

If you put an apostrophe in front of the = sign, this turns it to text
so that you can see the formula. You can then copy it to the nearby
cell and go back to the original cell and remove the apostrophe.

Hope this helps.

Pete

 

[Piers 2k]

Thanks Pete, but I need it to be dynamic.

The formula can change source reference, and will also be copied lots, so it
needs to be formula to update automatically.

Thanks though,

Piers

 

[Harlan Grove]

Piers 2k wrote...
....

Preferably I need to use built in functions, since this will be a new file
most times it's used.

I can do this in VBA, but is there anything built in?

No, there's nothing built in. You have to use VBA or an add-in.

 

[Piers 2k]

Thanks, I can stop looking now...

Piers