Mail Merge issue

I am using a word document to mail merge data from an excel spreadsheet. When i merge figures they appear perfect in the word doc if they are rounded, but if they are not rounded they appear with loads of figures after them for example if i place 5.5 in cell it will appear fine in the word doc but if i put 5.6 it would appear 5.5999999999999996 i would really appreciate any help. i have tried formatting it into different types text number s etc but no luck, i don't know where the error is?

What happens if you type in 5.5 preceded by an apostrophe '

Also you might be better off posting an a Word newsgroup since mailmerge is
done in Word

http://word.mvps.org/FAQs/MailMerge/index.htm

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"b_walls1" <b_walls1.25ncyy_1143998101.3312@excelforum-nospam.com> wrote in
message news:b_walls1.25ncyy_1143998101.3312@excelforum-nospam.com...
>
> I am using a word document to mail merge data from an excel spreadsheet.
> When i merge figures they appear perfect in the word doc if they are
> rounded, but if they are not rounded they appear with loads of figures
> after them for example if i place 5.5 in cell it will appear fine in
> the word doc but if i put 5.6 it would appear 5.5999999999999996 i
> would really appreciate any help. i have tried formatting it into
> different types text number s etc but no luck, i don't know where the
> error is?
>
>
> --
> b_walls1
> ------------------------------------------------------------------------
> b_walls1's Profile:
> http://www.excelforum.com/member.php...o&userid=33090
> View this thread: http://www.excelforum.com/showthread...hreadid=528997
>

your a star thanks a mill that worked using the ' but i don't know if we can get this fixed without using the '

Debra Dalgleish posted this to a similar question about formatting
dates/decimals.

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://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

b_walls1 wrote:
>
> I am using a word document to mail merge data from an excel spreadsheet.
> When i merge figures they appear perfect in the word doc if they are
> rounded, but if they are not rounded they appear with loads of figures
> after them for example if i place 5.5 in cell it will appear fine in
> the word doc but if i put 5.6 it would appear 5.5999999999999996 i
> would really appreciate any help. i have tried formatting it into
> different types text number s etc but no luck, i don't know where the
> error is?
>
> --
> b_walls1
> ------------------------------------------------------------------------
> b_walls1's Profile: http://www.excelforum.com/member.php...o&userid=33090
> View this thread: http://www.excelforum.com/showthread...hreadid=528997

--

Dave Peterson

Hi ....,

Assuming that you would not want such a column formatted as text you can still stay within
Excel by using a helper column using the TEXT Worksheet Funciton
G1: =TEXT(D1,"#,###.00") or other format of your choice.

Have used the above, not sure if I have actually used the following with Mail Merge
but I think it should work and it was likely Mail Merge that I created the function in the
first place..

Another way would be to use a user defined function
see my formula.htm page

Function GetText(Cell as Range) as String
On Error Resume Next
GetText = cell.Text
End Function

G1: =GetText(D1)
G1: =personal.xls!GetText(D1)

My page on Mail Merge is
http://www.mvps.org/dmcritchie/excel/mailmerge.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Peo Sjoblom" <peo.sjoblom@^^nwexcelsolutions.com> wrote in message news:%23v9AtFoVGHA.5580@TK2MSFTNGP11.phx.gbl...
> What happens if you type in 5.5 preceded by an apostrophe '
>
> Also you might be better off posting an a Word newsgroup since mailmerge is
> done in Word
>
> http://word.mvps.org/FAQs/MailMerge/index.htm
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Northwest Excel Solutions
>
> www.nwexcelsolutions.com
>
> (remove ^^ from email address)
>
> Portland, Oregon
>
>
>
>
> "b_walls1" <b_walls1.25ncyy_1143998101.3312@excelforum-nospam.com> wrote in
> message news:b_walls1.25ncyy_1143998101.3312@excelforum-nospam.com...
> >
> > I am using a word document to mail merge data from an excel spreadsheet.
> > When i merge figures they appear perfect in the word doc if they are
> > rounded, but if they are not rounded they appear with loads of figures
> > after them for example if i place 5.5 in cell it will appear fine in
> > the word doc but if i put 5.6 it would appear 5.5999999999999996 i
> > would really appreciate any help. i have tried formatting it into
> > different types text number s etc but no luck, i don't know where the
> > error is?
> >
> >
> > --
> > b_walls1
> > ------------------------------------------------------------------------
> > b_walls1's Profile:
> > http://www.excelforum.com/member.php...o&userid=33090
> > View this thread: http://www.excelforum.com/showthread...hreadid=528997
> >
>