| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MERGEFIELD - Numeric Picture - Insert decimal
I have a mergefield whose value is 123456 which I want to display as a
currency field $1,234.56. I have the same problem with numeric fields. The value in my datasource is 123456 and I want to display as 1,234.56 What Numeric Picuture of function can I use to accomplish this? Brenda |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
MERGEFIELD - Numeric Picture - Insert decimal
You can't do it with a switch alone. You will have to use a formula field to
divide by 100 to set the decimal point. {=({Mergefield fieldname} / 100) \# "$,0.00"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Brenda wrote: I have a mergefield whose value is 123456 which I want to display as a currency field $1,234.56. I have the same problem with numeric fields. The value in my datasource is 123456 and I want to display as 1,234.56 What Numeric Picuture of function can I use to accomplish this? Brenda |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Slow 'Insert Picture' | Microsoft Word Help | |||
| How do I insert a picture larger than 22 inches? | Microsoft Word Help | |||
| How to insert smart jumping ;) picture | Microsoft Word Help | |||
| Will the animation work if I insert an animated picture in Word? | Microsoft Word Help | |||
| How do I insert text over a picture without losing the picture? | Microsoft Word Help | |||
Linear Mode
