I like to Format a Col to 1'234.50 and found this sample but it's not
working.
 
can anyone help me ?
 
thx Kilian
 
    Dim objDFFrTausend  As StdFormat.StdDataFormat
 
    Set objDFFrTausend = New StdFormat.StdDataFormat
 
    objDFFrTausend.Format = "#,##0.00"
    
    Set .Columns.Item(9).DataFormat = objDFFrTausend