Posted to microsoft.public.word.mailmerge.fields
|
|
Displaying Two Decimal Places in Merged Excel Data
You are welcome
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Debs wrote:
Many thanks for you help Graham it works perfectly!
Debs
"Graham Mayor" wrote:
The formatting in Excel is irrelevant. Add a formatting switch to
the Word field
{Mergefield Fieldname \# "£,0.00" }
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
Debs wrote:
Hi
I would like to merge numerical data from Excel which has been
formatted as £1,000.10 in a Word doc. When I do this however in the
Word doc it does not display .10 but .1 even though it has been
formatted in Excel to show two characters after the decimal Point?
Any help most appreciated!
Debs
|