euro sign in font

[Guest]

Hi,

My company is using font ZapfHumnst in Word and Excel. It appears that that
the euro sign ( € ) in Excel correctly is represented, but not in Word. What
is the cause of the difference and what can I do torepresent this sign in
Word too?

Thanks for help,

Henk

 

[Graham Mayor]

There is no ? sign in the ZapfHumnst font (my default). What does ALT+CTRL+4
insert? Here it inserts ? from the Arial font - which does the job.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

In word we've a macro which inserts a € sign (in this reply inserted with
ctrl-alt-5) from another font, for ctrl-alt-5 creates an unreadable
character. However, in Excel, where I've also font ZapfHumnst as default,
ctrl-alt-5 inserts neatly a €-sign (without macro!). So that in Excel the €
seems to belong to the ZapfHumnst font (copy/paste the character in Word
gives that unreadable character) . Does both applications use different
font(-files)?

The problem arises when I copy a set of Excel cells with Finance/Currency
formatting in a Word table.

 

[Graham Mayor]

They both use the same font file Excel is presumably mapping some other font
to that character. Use a macro

Sub EuroSymbol()
Selection.InsertSymbol Font:="Arial", CharacterNumber:=8364,
Unicode:=True
End Sub

and map that to Ctrl+ALT+5 if that's where you want it.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

Hello, Graham!

With FontCreator 5.0 from High-Logic it's easy to add the euro sign to the
font.

Cheers,
Henk

 

[Graham Mayor]

But it's $65 (more for the Pro version)! The macro costs nothing.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>