Merge with Excel and decimal problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry - 08 May 2004 18:27 GMT

I have a very large spreadsheet that contains a column of
amounts representing dollars and cents, another column
which multiplies that column by a percentage and then a
resulting column that adds the two previous columns
together. I have formatted those columns to
be "general", "accounting", "currency", and "special" and
have set it to be two decimals only. The columns appear
in the spreadsheet with only two decimals but when i
merge the final column number in to a word document, i
get all the calculated decimals (5 or 6). How do I get
rid of the extra decimal points so that the letter shows
a dollar amount with only 2 decimals. Anyone's help
would be appreciated.
.

Reply to this Message

Doug Robbins - Word MVP - 09 May 2004 05:52 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 a very large spreadsheet that contains a column of
> amounts representing dollars and cents, another column
[quoted text clipped - 10 lines]
> would be appreciated.
> .

Reply to this Message