I have formatted some cells as currency type Euro but when I complete his formatting exercise the numbers don't show the Euro symbol. They show a small vertical bar, slightly subscript, before or after the figure depending on the type of euro I select.

Anyone seen this before and know how to get around it?

Thanks

Paul.