[AccessD] A2003: Replace the Hash Character

Hi All
 
I am trying to replace the # character in a table
 
I have about 3 hundred records and one of the fields in that 300 or so records
has data in it similar to #123-ABC
 
I want to Find and Replace the # with nothing so the data in the fields looks
like 123-ABC
 
When I do open the table and Use find and replace and use # as the searchable
item it actually finds all the numbers EG 3 4 6 etc in each record
 
Not the actual character
 
I have tried '#' and "#" in my search field - no joy
 
Anyone know how to do a find and replace on the actual character # not on
numbers?
 
MTIA
 
Darren