nagavineela
10-26-2010, 12:07 AM
Hi All,
Please help me in converting the decimal number in English to Spanish version. The code written is as follows:
txtavailability.Value = (1 / totfailrate) / ((1 / totfailrate) + ActiveSheet.Range("C4").Value) * 100
txtavailability.Value = Format(txtavailability.Value, "0.00000")
but the above line 3 of code value in Spanish is shown as 9.913.856 but in english version it is 99.1385 (correct value).
Please help me.
Thanks,
Vineela
Please help me in converting the decimal number in English to Spanish version. The code written is as follows:
txtavailability.Value = (1 / totfailrate) / ((1 / totfailrate) + ActiveSheet.Range("C4").Value) * 100
txtavailability.Value = Format(txtavailability.Value, "0.00000")
but the above line 3 of code value in Spanish is shown as 9.913.856 but in english version it is 99.1385 (correct value).
Please help me.
Thanks,
Vineela