TryParse method not returning required value

• Question

• 

  

  0

  Sign in to vote

  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