How to imbed a cell reference in a text field?
And I meant "Roger" not "Ron"
That's Ok Jim <vbg
--
Regards
Roger Govier
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
And I meant "Roger" not "Ron"
Gord
On Thu, 14 Dec 2006 10:40:11 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:
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?
Gord Dibben MS Excel MVP
|