You can avoid having Excel do one concatenation by moving the $ sign inside the TEXT function's pattern string...maybe...
="$"&TEXT(ROUND(G3,2),"0.00")& " per sq ft"
Actually, in thinking about it some more, we can eliminate both concatenations (the less work for Excel to do, the better)...Thanks Rick, I didn't think of doing it that way
The second argument to the TEXT function is a quoted text constant... in order to protect its characters from being interpreted as meta-characters to be acted on by the TEXT function, they need to be quoted... when you embed quoted text with the quote marks delineating a text constant, you must double up the quote marks surrounding the quoted text being embedded.that works...though I'm a little confused on how the double double quotes are working