Importing from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Doreen - 20 Dec 2004 16:33 GMT

Word and Excel 2002

I'm importing from Excel to Word.

When I import what looks like $12,000 in Excel, it becomes 12000 in Word. I
understand that's because the data is 12000 and in Excel I've formatted it
with Currency and Comma styles.

My question is, what's the easiest way to get $12,000 in Word without having
to manually fix each entry?

Thanks in advance.

Doreen

Reply to this Message

Suzanne S. Barnhill - 20 Dec 2004 16:44 GMT

There are two ways to approach this. In a mail merge, you can add a numeric
picture switch to the merge field. Or you can connect to Excel via DDE
instead of OLEDB. For more on both, see
http://homepage.swissonline.ch/cindymeister/MM2002/MM2002.htm

Signature

Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> Word and Excel 2002
>
[quoted text clipped - 10 lines]
>
> Doreen

Reply to this Message

Doreen - 20 Dec 2004 17:08 GMT

thanks, I'm a little unclear how to do it for percentages (its 7% in excel,
but 0.07 in word)

any ideas?

D

> There are two ways to approach this. In a mail merge, you can add a numeric
> picture switch to the merge field. Or you can connect to Excel via DDE
[quoted text clipped - 26 lines]
> >
> > Doreen

Reply to this Message

Graham Mayor - 20 Dec 2004 17:45 GMT

{ =({Mergefield Fieldname} * 100) \# "#%"}

Use a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> thanks, I'm a little unclear how to do it for percentages (its 7% in
> excel, but 0.07 in word)
[quoted text clipped - 31 lines]
>>>
>>> Doreen

Reply to this Message