TryParse method not returning required value RRS feed

  • Question

  • I am creating a spreadsheet on a PC in another European country using a custom built .Net program.   This system uses the  comma separator "," as a decimal separator.  When the spreadsheet is produced, the values I am concerned with are coming out as: "nnnn,nn"   I need them to come out as:  "nnnn.nn".   

    I have tried :

    Dim number as string "0.00"
    If strCustNo > 0 Then
    If Double.TryParse(strPrice, NumberStyles.Number, CultureInfo.CreateSpecificCulture("en-UK"), number) Then
    five(iRow, 0) = number 
    'new price
    End If
    End If

    Monday, June 10, 2013 1:13 PM