My apologies. You've prompted me to do a little more research and Format is much more sophisticated than I had thought it was. If you click in the middle of the word Format in the VBA Editor and click F1, you'll see the Help for the method.
You can try:
However, I'm not 100 sure how that helps because it looks, to me, as though the Format will output the 1 as a number, not a Text Value. So, it seems you would have to make the cell itself Text Format before putting something in it.
This appears to work:
Regards, TMS
Bookmarks