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)