Prev: Copy Form Text
Next: how do i email a form using a hyperlink? word 2007
From: greg on 17 May 2010 08:16
Hi, i am trying to merge a word document with an excel spreadsheet which
contains some field that are formated as currency in excel, however, when
they are merged with the word doc the numbers do not appear.

how do i format the merge field in the word document to appear as a number
e.g £1,234.90

please help
From: Peter Jamieson on 17 May 2010 08:26
In Word, use Alt-F9 to display the field(s) you want to format, e.g.

{ MERGEFIELD myamount }

Delete \*Mergeformat if you see it, and type in the following numeric format

\#£,0.00

so you have

{ MERGEFIELD myamount \#£,0.00 }

Use Alt-F9 to toggle back again.

Peter Jamieson

http://tips.pjmsn.me.uk

On 17/05/2010 13:16, greg wrote:
> Hi, i am trying to merge a word document with an excel spreadsheet which
> contains some field that are formated as currency in excel, however, when
> they are merged with the word doc the numbers do not appear.
>
> how do i format the merge field in the word document to appear as a number
> e.g £1,234.90
>
> please help
 | 
Pages: 1
Prev: Copy Form Text
Next: how do i email a form using a hyperlink? word 2007