I swear to Og, Excel makes me think I’m losing my marbles.
It used to be (before Word and Excel 2003) that if you used an Excel worksheet as your data source for a mail merge, the formatting of the Excel fields would be retained when you merged into Word.
Now it doesn’t retain the formatting (in my case, for currency). If I format the Excel field as $25.00, I want it to look exactly like that in my Word merged doc.
I do NOT want to enter field codes and switches and all that BS. Last time I researched this, there was something I either checked or unchecked in either Word or Excel so that when I went to chose my data source, it would ask if I wanted to use OLE or sumsuch.
I can’t find now where to check or uncheck… Does anyone know what I’m talking about and can help me, or am I being gaslighted by frickin’ Microsoft???