| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
British currency symbol £
Why, does the £ not show correctly 'sometimes' on a merged document created
by mail merge? Thanks. |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
British currency symbol £
AA2e72E wrote:
Why, does the £ not show correctly 'sometimes' on a merged document created by mail merge? Where does the pound sign come from? The (what) data source? Have you tried inserting it in Word directly (before or after a merge field)? Greetings Robert -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
British currency symbol £
See http://www.gmayor.com/formatting_word_fields.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org AA2e72E wrote: Why, does the £ not show correctly 'sometimes' on a merged document created by mail merge? Thanks. |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
British currency symbol £
Where does the pound sign come from?
It is part of the currency format specified for the field. The enigma is that it works but not always. |
|
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
British currency symbol £
If the data source is Excel or Access, then the data formatting is ignored
and must be applied to the fields. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org AA2e72E wrote: Where does the pound sign come from? It is part of the currency format specified for the field. The enigma is that it works but not always. |
|
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
British currency symbol £
AA2e72E wrote:
Where does the pound sign come from? It is part of the currency format specified for the field. In your data source, I presume? What is it? Excel? Depending on mail merge connection method to the data base, Word does not "see" formatting of fields, say, in Excel. You then need to choose a different connection method or format the field in Word (or, as in this case, simply add the Pound sign there): Date, Phone Number, and Currency fields are merged incorrectly when you use an Access or Excel data source in Word http://support.microsoft.com/?scid=k...04387&x=8&y=10 Force Word to use the number format you want (by Cindy Meister) http://homepage.swissonline.ch/cindy....htm#NumFormat HTH Robert -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get Word to recognise British spellings? | Microsoft Word Help | |||
| How do I format merge fields to show a currency symbol? | Mailmerge | |||
| Sterling currency symbol | Page Layout | |||
| Currency fields in Access lose th currency format whn merged why | Mailmerge | |||
| Where is the currency symbol for cents? | Microsoft Word Help | |||
Linear Mode
