Hi

Another alternative, with a slight difference in layout would be to
Custom format the cell.
FormatCellsNumberCustom #0.00 "$ Cost / hour"

Then in the cell just enter
=E7

The possible advantage is the number value generated from the E7 value
is still a number and can be used in further calculation if required.

--
Regards

Roger Govier


"LurfysMa" wrote in message
...
On Thu, 14 Dec 2006 05:48:30 -0800, LurfysMa
wrote:

Is there a way to imbed the value in a cell in a text field?

Something like: "Cost at [E7] / hour.", where "[E7]" gets replaced by
the value in cell E7.

I found the answer. Use the concatenate function:

=CONCATENATE("Cost at $",E7,"/hour.")

Thanks

--
Running Excel 2000 SP-3 on Windows 2000