Unabel to find and replace the date format and number format form excel to word using VBA

Hello everyone,

I am new to excel VAB tyring to learn. i have tried to perform a small action of finding and replacing the data in Word 2013 using the excel VBA, and it runs successfully except for the date and number format.

The date i have in the Excel is December 12 2019, but when it is being copied and found and replaceed in Word it is pasted as date# (Number) 45636, and the number that i have in excel is 1080 and it is pasted as 1080.3333333.

I am not able to format the date and numbers as per the excel format, and at the end. I tried to save the word and convert it to PDF, but have no idea on how to write the code. I am using the code as below

Please Login or Register  to view this content.

Could some one please help me in formating the Date (as December 12, 2019) , Nunber (With no decimal Value) and converting the word to PDF.

Thanks in advacne for the help.

Kind Regards,
Vishnu T

Thanks for the help Alan, i will follw the Forum rules correctly next time