I can't believe something as obvious as retaining the formats from the Excel sheet to the merged Word document isn't part of the programming for these applications!!
I have read all the help on this topic and tried to use the stupid formatting switches in the field codes to no avail.
I have a numeric field that I want formatted as a dollar field. I have used "alt f9" to go into the field code and edited as follows:
{MERGEFIELD"Orig_Prin" \ # $#,##0.00}
"Orig_Prin" is a field name from my Excel file. In Excel, the data is formated to appear "$6,000.00", but no matter what I try, it shows up in the merged doc as "6000".
This makes me so mad, I have spent so much time on it I could have typed all the letters on a manual typewriter by now!! Please help.
Thanks,
JPF