I spent twenty minutes today, arsing around with the format of some cells that were set as Euro but were showing as a I or possibly an l
And then it occurred to me... the text SIZE was too small..... I increased from Calibri 11 to Calibri 12....and bingo...
the cell just coudn't show the € symbol as an 11 sized character.
Lesson learned....hope it helps someone