Using Office 2003

I have a Word doc merging with some data in XLS. In the xls field, I have
chosen the currency format and it looks fine. (ex. $125.75)

When I merge it in Word, it comes over as 125.75 and I have no idea how to
tell it to use the format I have set up in xls.

Please help.!

Thanks in advance.

Phil

Debra Dalgleish posted this to a similar question:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://home.earthlink.net/~wordfaqs/...ngWord2002.htm

about half way down the page.

==========
Another way is to cheat!

Use a helper cell with a formula like:
=text(a1,"$##0.00")
and copy down

This will be treated like text in your mail merge.

Phillip Vong wrote:
>
> Using Office 2003
>
> I have a Word doc merging with some data in XLS. In the xls field, I have
> chosen the currency format and it looks fine. (ex. $125.75)
>
> When I merge it in Word, it comes over as 125.75 and I have no idea how to
> tell it to use the format I have set up in xls.
>
> Please help.!
>
> Thanks in advance.
>
> Phil

--

Dave Peterson

Thanks so much!!!! That fixed it!

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Debra Dalgleish posted this to a similar question:
>
> There's an article on the Microsoft web site that might help you:
>
> Answer Box: Numbers don't merge right in Word
> http://office.microsoft.com/en-ca/as...164951033.aspx
>
> And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
> has instructions here:
>
> http://home.earthlink.net/~wordfaqs/...ngWord2002.htm
>
> about half way down the page.
>
> ==========
> Another way is to cheat!
>
> Use a helper cell with a formula like:
> =text(a1,"$##0.00")
> and copy down
>
> This will be treated like text in your mail merge.
>
> Phillip Vong wrote:
>>
>> Using Office 2003
>>
>> I have a Word doc merging with some data in XLS. In the xls field, I
>> have
>> chosen the currency format and it looks fine. (ex. $125.75)
>>
>> When I merge it in Word, it comes over as 125.75 and I have no idea how
>> to
>> tell it to use the format I have set up in xls.
>>
>> Please help.!
>>
>> Thanks in advance.
>>
>> Phil
>
> --
>
> Dave Peterson

Just curious--which one?

Phillip Vong wrote:
>
> Thanks so much!!!! That fixed it!
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Debra Dalgleish posted this to a similar question:
> >
> > There's an article on the Microsoft web site that might help you:
> >
> > Answer Box: Numbers don't merge right in Word
> > http://office.microsoft.com/en-ca/as...164951033.aspx
> >
> > And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
> > has instructions here:
> >
> > http://home.earthlink.net/~wordfaqs/...ngWord2002.htm
> >
> > about half way down the page.
> >
> > ==========
> > Another way is to cheat!
> >
> > Use a helper cell with a formula like:
> > =text(a1,"$##0.00")
> > and copy down
> >
> > This will be treated like text in your mail merge.
> >
> > Phillip Vong wrote:
> >>
> >> Using Office 2003
> >>
> >> I have a Word doc merging with some data in XLS. In the xls field, I
> >> have
> >> chosen the currency format and it looks fine. (ex. $125.75)
> >>
> >> When I merge it in Word, it comes over as 125.75 and I have no idea how
> >> to
> >> tell it to use the format I have set up in xls.
> >>
> >> Please help.!
> >>
> >> Thanks in advance.
> >>
> >> Phil
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

Dave,

I used the DDE and it worked on the first try.
Thanks again!

Phil


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Just curious--which one?
>
> Phillip Vong wrote:
>>
>> Thanks so much!!!! That fixed it!
>>
>> "Dave Peterson" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Debra Dalgleish posted this to a similar question:
>> >
>> > There's an article on the Microsoft web site that might help you:
>> >
>> > Answer Box: Numbers don't merge right in Word
>> > http://office.microsoft.com/en-ca/as...164951033.aspx
>> >
>> > And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
>> > has instructions here:
>> >
>> > http://home.earthlink.net/~wordfaqs/...ngWord2002.htm
>> >
>> > about half way down the page.
>> >
>> > ==========
>> > Another way is to cheat!
>> >
>> > Use a helper cell with a formula like:
>> > =text(a1,"$##0.00")
>> > and copy down
>> >
>> > This will be treated like text in your mail merge.
>> >
>> > Phillip Vong wrote:
>> >>
>> >> Using Office 2003
>> >>
>> >> I have a Word doc merging with some data in XLS. In the xls field, I
>> >> have
>> >> chosen the currency format and it looks fine. (ex. $125.75)
>> >>
>> >> When I merge it in Word, it comes over as 125.75 and I have no idea
>> >> how
>> >> to
>> >> tell it to use the format I have set up in xls.
>> >>
>> >> Please help.!
>> >>
>> >> Thanks in advance.
>> >>
>> >> Phil
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson

Thanks for posting back.

Phillip Vong wrote:
>
> Dave,
>
> I used the DDE and it worked on the first try.
> Thanks again!
>
> Phil
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Just curious--which one?
> >
> > Phillip Vong wrote:
> >>
> >> Thanks so much!!!! That fixed it!
> >>
> >> "Dave Peterson" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > Debra Dalgleish posted this to a similar question:
> >> >
> >> > There's an article on the Microsoft web site that might help you:
> >> >
> >> > Answer Box: Numbers don't merge right in Word
> >> > http://office.microsoft.com/en-ca/as...164951033.aspx
> >> >
> >> > And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
> >> > has instructions here:
> >> >
> >> > http://home.earthlink.net/~wordfaqs/...ngWord2002.htm
> >> >
> >> > about half way down the page.
> >> >
> >> > ==========
> >> > Another way is to cheat!
> >> >
> >> > Use a helper cell with a formula like:
> >> > =text(a1,"$##0.00")
> >> > and copy down
> >> >
> >> > This will be treated like text in your mail merge.
> >> >
> >> > Phillip Vong wrote:
> >> >>
> >> >> Using Office 2003
> >> >>
> >> >> I have a Word doc merging with some data in XLS. In the xls field, I
> >> >> have
> >> >> chosen the currency format and it looks fine. (ex. $125.75)
> >> >>
> >> >> When I merge it in Word, it comes over as 125.75 and I have no idea
> >> >> how
> >> >> to
> >> >> tell it to use the format I have set up in xls.
> >> >>
> >> >> Please help.!
> >> >>
> >> >> Thanks in advance.
> >> >>
> >> >> Phil
> >> >
> >> > --
> >> >
> >> > Dave Peterson
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson