Failure to import currency format from Excel.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sweeneysmsm - 05 Jan 2006 19:07 GMT

Am using Office 2003. I have a mail-merge letter which is designed to get
data from an .xls file. I am writing thank-you letters and consequently there
is an "Amount" field which has currency data - e.g. $25.00. When the amount
comes over into the merge letter it appears as "25". I suppose I can remedy
this by putting"$<Amount>.00" but this hardly seems very elegant. Is there
another way to fix this?

Thanks for any help.

Mary

Reply to this Message

Doug Robbins - Word MVP - 06 Jan 2006 04:57 GMT

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

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Am using Office 2003. I have a mail-merge letter which is designed to get
> data from an .xls file. I am writing thank-you letters and consequently
[quoted text clipped - 9 lines]
>
> Mary

Reply to this Message

sweeneysmsm - 06 Jan 2006 15:39 GMT

Thank you so much. Yes, I put in the switches. I can't say that I feel the
process is "friendly", but we do what we have to do.

Thank you again.

Mary

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 14 lines]
> >
> > Mary

Reply to this Message