Posted 8 September 2017, 1:26 pm EST
We have a column which has to be double because of calculations. The resultant calculation is always a whole number so I assigned a NumberCellType to the column as below. I know the cell type is active because the decimals are not being displayed. The problem is that the thousands separator is not displaying. I am using 2001.2005 in VS2005. Thanks in advance for any ideas and/or suggestions!
Dim cellType As New CellType.NumberCellType
cellType.DecimalPlaces = 0
cellType.Separator = ","
column.CellType = cellType