Typically you can either use formatting "switches" in your Word fields - see
Graham Mayor's page at
http://www.gmayor.com/formatting_word_fields.htm for
that. (Incidentaly, this same reply has been provided about 4 times inth
last couple of hours - it really helps if you can look through recent posts
in these groups because the answer is often there).
Or, if you only have ANSI characters inyour Excel workbook and you only need
to connect to the first sheet in the book, you can change the "connection
method" to use DDE rather than the default in Word 2002 and later, which is
OLE DB. To do thatin Word 2002/2003, go to Word Tools|Options|General, check
Confirm Conversions at open, go through the connection process again and
select the DDE option when offered. For Word 2007, you should find a similar
option near the bottom of Word-Office button-Word options-Advanced. In
that case, you may need to check "Show All" in the "COnfirm Data Source"
dialog if the file is a .xlsx or .xslm format file.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"barjas" wrote in message
...
I am trying to merge some calculations from Excel into my Word document. I
am not able to get the numbers to display properly, ie. percentages as
percentages and dollars as dollars and not just large number strings. I
had
found a solution that worked so I know it's possible, but I forgot what it
was and have not been able to find the solution again. Any suggestions
are
wonderfully appreciated, I have been researching this for many many hours.
--
Barjas