Paste number from EXCEL to WORD and retain formatting

[DKolev]

Guys,

I am importing a data table from Excel into word. All works well except for the first column of my data, which contains numbers formatted as currency. I am using a bunch of loops to transfer the data into word, and for each cell the code looks like this:

Please Login or Register  to view this content.

Is there a way to tweak the code and preserve the formatting when I am importing numbers into word?

I tried the following code but it gives me type mismatch error:

Please Login or Register  to view this content.

Thanks,

D.

[xladept]

Check out word's FormatCurrency Function