Set the format cell in a excel sheet.

Hi,
im writting data back to an excel sheet. But there is one cell that i need to set the format to Number with few decimals. At the moment the cells are formatted as general.
So how can i change the format type in excell sheet from vb.net?
LVL 8
arcrossAsked:
Who is Participating?
 
bluntTonyConnect With a Mentor Commented:
I think to set the cell format you can use something similar to this:
wb.Worksheets("Sheet1").Columns("A:A").NumberFormat = "#,#.00"
This example sets the format of column A  to a number with thousand seperator and two decimal places.
Hope this helps...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.