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