Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Importing from Excel
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 |
#2
|
|||
|
|||
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/cindy...002/MM2002.htm -- 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. "Doreen" wrote in message ... 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 |
#3
|
|||
|
|||
thanks, I'm a little unclear how to do it for percentages (its 7% in excel,
but 0.07 in word) any ideas? D "Suzanne S. Barnhill" wrote in message ... 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/cindy...002/MM2002.htm -- 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. "Doreen" wrote in message ... 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 |
#4
|
|||
|
|||
{ =({Mergefield Fieldname} * 100) \# "#%"}
Use a formatting switch on the field - http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Doreen wrote: thanks, I'm a little unclear how to do it for percentages (its 7% in excel, but 0.07 in word) any ideas? D "Suzanne S. Barnhill" wrote in message ... 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/cindy...002/MM2002.htm -- 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. "Doreen" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting an Excel spreadsheet into Word - how to remove gridl | Tables | |||
Importing an excel file (each cell is formatted as a label) into . | Mailmerge | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
WORD 2000 pages layout when EXCEL table inserted | Page Layout | |||
Word Field Codes in Excel data file | Mailmerge |