Hi Hugh:
The Retired Guy loves to answer the Financial Reporter challenges, but in case you're in a hurry:
If G4 contains '3 (note the leading single quote, just like in Excel)
Then your Colspec cell would be : ="{"&G4&"}"&"M" (The brackets are brace brackets)