We help IT Professionals succeed at work.

exporting a money field to excel

RIAS
RIAS asked
on
Hello,
I am exporting datagridview to excel .
The money field which has values like :
61,999.65  from datagridview gets exported as 61999.65
how to get comma , exported?


 xlRange = xlWorkSheet.Range("H1")
                    xlRange.EntireColumn.NumberFormat = "#,##0.00"
Comment
Watch Question

The NumberFormat you show should give the correct display (commas for thousands, two digits after the decimal) in Excel. I'd do it as

 xlWorkSheet.Range("H:H").NumberFormat = "#,##0.00"

Author

Commented:
Thanks will try and get back

Author

Commented:
Thanks mate!