Data Exported from Access to Excel

[Guest]

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

 

[David McRitchie]

Use cell format to format the data you want or use TEXT Worksheet Function
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

 

[aidan.heritage]

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.

 

[Guest]

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