Macro that transfers data from excel to word document and then saves document as pdf file

[mlcfexcel]

Dear all,

I've prepared a simple macro that transfers data from excel to word document and then saves document as pdf file.
Everything looks good except for the currency value i.e, I cannot paste it into word with the correct currency format.
Any hint how could I do it?

Regards

[NickyC]

could you convert the value to a string before you copy it?

[mlcfexcel]

Yes that's the solution! Thank you for the help!