sherri said:
just update to office 2003. doing mail merge. excel sheet has interest rate
formated percentage 3 decimal places. When I complete the merge it shows up
with 7.5000001. Help. Also happening in my numberic fields.
First you need to realize that format has nothing to do with how the
value is stored in a cell (except for Text). Format simply affects
display, in a merge, Word gets the value, not the displayed value.
IMO, the best option is to format your Word field, but for WinOffice, MS
prefers DDE, both of which are explained here:
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx
Note that you've posted in a Mac XL newsgroup - in this case, as in most
cases, the answer is the same, but if you have specific questions you
should direct them to one of the microsoft.public.excel* newsgroups.
