I would like to create a macro in Excel that would insert a special character (lozenge) ◊. I go to the Developer page and select Record Macro. I give it a shortcut name (ctrl-D) then go through the steps to insert the symbol and end the recording. When I run it, though, it inserts a question mark. Is it not possible to do what I want? I've tried editing the macro after I've created it, but that won't let me insert the lozenge, either.

Any help will be appreciated. If it is indeed impossible to insert this symbol, are there other symbols I can insert? Thanks.