Excel data merged into Word changes decimal places

[Alice Frazer]

I have a simple Excel spreadsheet where the data cells are formatted as accounting with a dollar sign (have also tried currency and number). When I merge the fields into Word, it changes the decimal places. I need the decimals to stay at 2 places as this number is to show currency.

 

[macropod]

Hi Alice,

In your word document, add the required numeric picture
switch to the mergefield, eg:
{mergefield XLdata \@ $,0.00}

Cheers

-----Original Message-----
I have a simple Excel spreadsheet where the data cells

are formatted as accounting with a dollar sign (have also
tried currency and number). When I merge the fields into
Word, it changes the decimal places. I need the decimals
to stay at 2 places as this number is to show currency.

 

[Peter Jamieson]

Minor typo -# needed for numeric formats, e.g.

{ mergefield XLdata \#$,0.00 }

 

[Peggy]

I have the same problem but I don't understand the response. Please elaborate. Thanks
----- Alice Frazer wrote: ----

I have a simple Excel spreadsheet where the data cells are formatted as accounting with a dollar sign (have also tried currency and number). When I merge the fields into Word, it changes the decimal places. I need the decimals to stay at 2 places as this number is to show currency.