Data Exported from Access to Excel

B

bigitch

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
 
A

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.
 
Top