currency not showing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pat@sitemaker1.com - 16 Jan 2004 17:31 GMT

Hi
I have Office 2003 and an excel spreadsheet showing
currency (£) as one of the "fields". When I merge it into
word the currency loses its £ sign and loses a decimal
point ie shows £23.50 as 23.5
Any ideas please

Reply to this Message

Graham Mayor - 16 Jan 2004 17:41 GMT

This is intentional - you can use a switch on the mergefield to format it
correctly - see http://www.gmayor.com/formatting_word_fields.htm

see also

the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm for a method that
will bring the formatting from Excel.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hi
> I have Office 2003 and an excel spreadsheet showing
> currency (?) as one of the "fields". When I merge it into
> word the currency loses its ? sign and loses a decimal
> point ie shows ?23.50 as 23.5
> Any ideas please

Reply to this Message

- 16 Jan 2004 19:16 GMT

Thanks Graham
much appreciated

Pat

>-----Original Message-----
>This is intentional - you can use a switch on the mergefield to format it
[quoted text clipped - 9 lines]
>> I have Office 2003 and an excel spreadsheet showing
>> currency (£) as one of the "fields". When I merge it

into

>> word the currency loses its £ sign and loses a decimal
>> point ie shows £23.50 as 23.5
>> Any ideas please
>
>.

Reply to this Message