Word letter Merge with Excel using numbers excluding decimal places

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Letitia - 24 Mar 2004 01:14 GMT

I have written a letter in Word and would like to use
data from Excel, but not to include the decimal places in
the letter. In the Excel field there are decimal places,
but I do not want this to occur in our letter.

How do I format/adjust this to include just a whole
number?

Many thanks

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 24 Mar 2004 01:22 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

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 have written a letter in Word and would like to use
> data from Excel, but not to include the decimal places in
[quoted text clipped - 5 lines]
>
> Many thanks

Reply to this Message