fractions instead of decimals in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Johnny - 23 Oct 2003 16:23 GMT

I am running Word and Excel 2002 on a Windows XP machine.

There is a cell in excel I formatted to make it
fractional instead of a decimal. When I mail merge it
into word it converts it back into a decimal. Thank you.

Reply to this Message

Doug Robbins - Word MVP - 24 Oct 2003 09:17 GMT

Hi Johnny,

To get it to come appear that way, you would have to store the numerator and
the divisor in separate columns so that you could have two mergefields with
/ between them in your mailmerge main document.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I am running Word and Excel 2002 on a Windows XP machine.
>
> There is a cell in excel I formatted to make it
> fractional instead of a decimal. When I mail merge it
> into word it converts it back into a decimal. Thank you.

Reply to this Message

Dick - 24 Oct 2003 16:11 GMT

Johnny and Doug
An alternative I use for odd situations like this is to
create a separate excel column in the format needed, then
copy and paste over the entire column with paste
special "values only", which would give you a field with
text like "1/25" already in it. The excel column field
can be automated (eg fx(a1+b2&" other stuff") to make an
entire calculated or reference entry to merge all in one
place. If you automate a column for future use, save it,
and only copy and paste "values only" just before
merging. Once merge is done it will ask you to save the
excel sheet before closing - choose no - or "values only"
in that column will overwrite your automated formula.

>-----Original Message-----
>Hi Johnny,
[quoted text clipped - 16 lines]
>
>.

Reply to this Message