Data Exported from Access to Excel

When I export data from Access to excel, then reformat the numeric fields to
the format needed, the spreadsheet looks fine. When I link to the spreadsheet
in a Word Mail Merge Document, that numeric value is many decimal places long
.. . . nowhere near what the spreadsheet shows. Any ideas ? ? ? Thanks

Use cell format to format the data you want or use TEXT Worksheet Function
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"bigitch" <bigitch@discussions.microsoft.com> wrote in message news:BF6CA9C2-B091-48DD-9A24-8F801F1950EB@microsoft.com...
> When I export data from Access to excel, then reformat the numeric fields to
> the format needed, the spreadsheet looks fine. When I link to the spreadsheet
> in a Word Mail Merge Document, that numeric value is many decimal places long
> . . . nowhere near what the spreadsheet shows. Any ideas ? ? ? Thanks

Or (and my preferred solution) put a formatting switch on the merge
field in word - in my experience, having the cell formatted a
particular way does NOT alter what Word puts in the merge, but using
field codes in Word to force it down a particular path does give you
the solution. Tagging \# "#,##0.00 at the end of the merge field
(just before the closing brace) will give you a 2 decimal place value,
formatted with commas.

Thanks to both of you . . . I'll try both and see which meets the need. . .

"aidan.heritage@virgin.net" wrote:

> Or (and my preferred solution) put a formatting switch on the merge
> field in word - in my experience, having the cell formatted a
> particular way does NOT alter what Word puts in the merge, but using
> field codes in Word to force it down a particular path does give you
> the solution. Tagging \# "#,##0.00 at the end of the merge field
> (just before the closing brace) will give you a 2 decimal place value,
> formatted with commas.
>
>