Try formatting the columns that the data appears in or
you could use a range as your selection. Here modify the
columns to your need or change the selection to a range:

Columns("D:P").Select
Selection.NumberFormat = "$#,##0"

Regards,
Alex.



-----Original Message-----
I have a co-worker who is extracting data from SQL
Server,
and using VB to create a spreadsheet. Everything is
working fine, except for the fact that he can't seem to
get the CURRENCY values to format within the
spreadsheet.
He can get them to appear as numbers, with decimals but
not in CURRENCY format. Any ideas?
.