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

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
Word MVP web site http://word.mvps.org




hstijnen wrote:
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

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" wrote:

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
Word MVP web site http://word.mvps.org




hstijnen wrote:
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

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
Word MVP web site http://word.mvps.org




hstijnen wrote:
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" wrote:

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
Word MVP web site http://word.mvps.org




hstijnen wrote:
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

Hello, Graham!

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

Cheers,
Henk

"Graham Mayor" wrote:

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
Word MVP web site http://word.mvps.org




hstijnen wrote:
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" wrote:

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
Word MVP web site http://word.mvps.org




hstijnen wrote:
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

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




hstijnen wrote:
Hello, Graham!

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

Cheers,
Henk

"Graham Mayor" wrote:

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
Word MVP web site http://word.mvps.org




hstijnen wrote:
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" wrote:

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
Word MVP web site http://word.mvps.org




hstijnen wrote:
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