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: www.excelforum.com/member.php...oamp;userid=33090
View this thread: www.excelforum.com/showthread...hreadid=528997What 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
word.mvps.org/FAQs/MailMerge/index.htm
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
quot;b_walls1quot; gt; wrote in
message ...
gt;
gt; I am using a word document to mail merge data from an excel spreadsheet.
gt; When i merge figures they appear perfect in the word doc if they are
gt; rounded, but if they are not rounded they appear with loads of figures
gt; after them for example if i place 5.5 in cell it will appear fine in
gt; the word doc but if i put 5.6 it would appear 5.5999999999999996 i
gt; would really appreciate any help. i have tried formatting it into
gt; different types text number s etc but no luck, i don't know where the
gt; error is?
gt;
gt;
gt; --
gt; b_walls1
gt; ------------------------------------------------------------------------
gt; b_walls1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33090
gt; View this thread: www.excelforum.com/showthread...hreadid=528997
gt;
your a star thanks a mill that worked using the ' but i don't know if we
can get this fixed without using the '--
b_walls1
------------------------------------------------------------------------
b_walls1's Profile: www.excelforum.com/member.php...oamp;userid=33090
View this thread: www.excelforum.com/showthread...hreadid=528997Debra 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
office.microsoft.com/en-ca/as...164951033.aspx
And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he
sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm
about half way down the page.
b_walls1 wrote:
gt;
gt; I am using a word document to mail merge data from an excel spreadsheet.
gt; When i merge figures they appear perfect in the word doc if they are
gt; rounded, but if they are not rounded they appear with loads of figures
gt; after them for example if i place 5.5 in cell it will appear fine in
gt; the word doc but if i put 5.6 it would appear 5.5999999999999996 i
gt; would really appreciate any help. i have tried formatting it into
gt; different types text number s etc but no luck, i don't know where the
gt; error is?
gt;
gt; --
gt; b_walls1
gt; ------------------------------------------------------------------------
gt; b_walls1's Profile: www.excelforum.com/member.php...oamp;userid=33090
gt; View this thread: 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,quot;#,###.00quot;) 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
www.mvps.org/dmcritchie/excel/mailmerge.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm
quot;Peo Sjoblomquot; gt; wrote in message ...
gt; What happens if you type in 5.5 preceded by an apostrophe '
gt;
gt; Also you might be better off posting an a Word newsgroup since mailmerge is
gt; done in Word
gt;
gt; word.mvps.org/FAQs/MailMerge/index.htm
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;b_walls1quot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; I am using a word document to mail merge data from an excel spreadsheet.
gt; gt; When i merge figures they appear perfect in the word doc if they are
gt; gt; rounded, but if they are not rounded they appear with loads of figures
gt; gt; after them for example if i place 5.5 in cell it will appear fine in
gt; gt; the word doc but if i put 5.6 it would appear 5.5999999999999996 i
gt; gt; would really appreciate any help. i have tried formatting it into
gt; gt; different types text number s etc but no luck, i don't know where the
gt; gt; error is?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; b_walls1
gt; gt; ------------------------------------------------------------------------
gt; gt; b_walls1's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=33090
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=528997
gt; gt;
gt;
