| View previous topic :: View next topic |
| Author |
Message |
Debs
Guest
|
 Posted: Thu Dec 20, 2007 2:27 pm Post subject: Displaying Two Decimal Places in Merged Excel Data |
 |
|
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 |
|
| Back to top |
|
 |
Google
Sponsor
|
| Posted: Thu Dec 20, 2007 2:27 pm Post subject: Advertisement |
|
|
|
|
| Back to top |
|
|
Graham Mayor
Guest
|
| Posted: Thu Dec 20, 2007 2:53 pm Post subject: Re: Displaying Two Decimal Places in Merged Excel Data |
|
|
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:
| Quote: | 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 |
|
|
| Back to top |
|
|
Debs
Guest
|
| Posted: Thu Dec 20, 2007 3:35 pm Post subject: Re: Displaying Two Decimal Places in Merged Excel Data |
|
|
Many thanks for you help Graham it works perfectly!
Debs
"Graham Mayor" wrote:
| Quote: | 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
|
|
|
| Back to top |
|
|
Graham Mayor
Guest
|
| Posted: Thu Dec 20, 2007 3:48 pm Post subject: Re: 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:
| Quote: | 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 |
|
|
| Back to top |
|
|
|
