Replace Formatted Numbers with text
Posted on 2016-08-10
We are having problems with a Microsoft Word merge using a large Excel file as a data source. Using DDE, the format used to transfer with the data. Now we lose all formatting and can't seem to get DDE to work.
If we format numbers as text such as "$ 19,599.25" then the numbers come over formatted as text. Does anyone know of any way to change the cells from numeric format (Say, currency) to text formatted the same? Can I do this with a macro?
Thanks for your help!