Variables in text

[neilpateluk]

Hi,

I have a summary table that contains percentages and various values. Then at the bottom the the excel sheet I have a summary conclusion that refers to these values.

Is there any way to have the text contain cell references in them so that they change as the data table changes?

So for example, 'This week Tim Strange's class achieved an average of 90%', and have the 90% change if its changed in the table?

Thanks,

[shg]

="This week Tim Strange's class achieved an average of " & TEXT(A1, "0%")

[neilpateluk]

This works great, except for one thing.

When using & TEXT(A1, "0") to copy a cell value that contains a currency, i.e. £120.16, it doesn't copy the .16, but only returns 120? Any way to fix this so it shows the full value?

[JBeaucaire]

Change 0 to 0.00

The "0.00" describes the format you want the TEXT string to take, so make your example in the quotes match the appearance you want.