Euro symbol using Accounting format in Excel

[Anthony]

Hi there,

We have an excel spreadsheet with accouting information in it.
We use both AU "$" and EUR "€" symbols.
We format the columns to have Accounting category using the "€ Euro (€ 123)"
format.
The cells appear correctly until we change the font to be our Custom font,
Helvetica.

When we do this, the "€" symbol changes to a "•"

Now, before you all say "there must be something wrong with the font, use
another one" there is more to this story!

I have tried 4 other machines, all using Office 2003 SP2 with the same
custom fonts installed and it all works and displays correctly. (There are
two troubled machines and they both have Office 2003 SP2)

Does anyone have any ideas?

 

[Anthony]

OK, solved it.
First I tried reinstalling the fonts over the top of the previous ones.
Didn't work.
I completely removed the old ones, then reinstalled again and it now works.