My best guess:

A1 = a numeric value formatted as Percentage to one decimal place.

="Sales for the period was "&TEXT(A1,"0.0%")&" of plan."

--
Biff
Microsoft Excel MVP


"orcini" wrote in message
...
Hi all,

I am creating a fairly extensive group of sheets that reference a data
table
at the start of the workgroup. I have to do some descriptive text within
the
sheet and have to reference the cells holding the "percentage" for
instance.
This percentage will change from time to time and i would like the
descriptive text to be the same but reflect the percentage change only.

Currently i have worded it so i can place the descriptive text in one cell
and the percentage in the adjoining cell but this is becomming more
difficult
for formatting.

I am assuming that there is some way to create something like a hyperlink
to
refer to the cell but the link won't display a change only that there is a
link. This will be printed as a final version and there will be no
opportunity for the reader to click anything.

Suggestions appreciated.