Insert 'pound' sign in forum response

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
8,515
When I copy/pasted a suggested macro into a response to another forum member, the macro contained a 'pound' sign but when pasted into the response, it came out as a question mark. Is there a way to have it pasted while keeping the original format?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,270
Office Version
365
Platform
Windows
Works for me
Code:
Sub chk()
 MsgBox "This will cost you £20.00  :-)"
End Sub
What was the thread?
 
Last edited:

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
8,515
Thank you for the quick response. Before I posted my question, I actually tried a few times to post the same macro in a response and got the same result, a question mark instead of a pound sign. I just went back to the thread and now the pound sign has replaced the question mark. Very strange!!!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,270
Office Version
365
Platform
Windows
I happened to see the post, so I changed it back to a Pound sign.
It's probably something to do with keyboard/regional settings, but not sure how to get round it.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,270
Office Version
365
Platform
Windows
You're welcome :)
 

Forum statistics

Threads
1,082,137
Messages
5,363,348
Members
400,729
Latest member
Lisa McConachy

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top