How to imbed a cell reference in a text field?
What Ron meant was if you entered Max's formula of
="Cost at "&TEXT(E7,"$#,##0.00") &"/hour"
You could not use that cell in calculations.
If you custom formatted a cell as Ron suggested, the cell could be used in
calculations because it is not text.
Gord Dibben MS Excel MVP
On Thu, 14 Dec 2006 09:02:41 -0800, LurfysMa wrote:
I don't understand. Why would I not just use E7 in any further
calculations?
|