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