macro to format cell

[minority]

hi,

i created a macro to copy specified columns from 1 report (rpt1)  to another (rpt2).
my problem is when i paste the value over, the format doesn't follow as well.

may i know the syntax to format a column or cell to currency format?

i've searched through the user guide but can't fiind any idea. please help. thanks!