Two ' should work where " doesn't
In reply to a post
Strictly that produces 2 single quotes, but neat thinking.
Just add the following to any cell formula
But that doesn't then permit the cell to be referred to in another formula (OK, I hadn't actually said I wanted to be able to that
Use the escape character \ on any special symbol to use it. Like a regexp.
That's it, thank you. I didn't want the red and only 1 decimal place but that was trivial to change. It's odd though, I'd tried the backslash as an escape but it didn't seem to work, I suspect I hadn't quite got the format right.
And thank you to philippercival for his input.
All good stuff, many thanks.